locked
Access to sql RRS feed

  • 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>

    Wednesday, November 30, 2011 1:47 PM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 30, 2011 1:51 PM

All replies

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 30, 2011 1:51 PM
  • User-431851830 posted

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

    Wednesday, November 30, 2011 2:15 PM
  • User1508394307 posted

    Glad it helped!

    Wednesday, November 30, 2011 2:21 PM