Access to sql

Question

User-431851830 posted

I'm transferring access db to SQL using sql management studio Import wizard.<o:p></o:p>

Getting following error<o:p></o:p>

Messages
Error 0x80004005: Data Flow Task 1:  (SQL Server Import and Export Wizard)
 
Error 0xc0208265: Data Flow Task 1: Failed to retrieve long data for column "Comments".
 (SQL Server Import and Export Wizard)<o:p></o:p>

Need help ASAP.<o:p></o:p>

Answer 1

User1508394307 posted

Check this thread, especially the post with "I started searching the memo field in the Access database. The last row contained '#Error' in the memo field. When I clicked in that field I got the following message..."

Hope this helps.

Answer 2

User-431851830 posted

Thanks you so much. You saved my day :).

Answer 3

User1508394307 posted

Glad it helped!