Export tables from SQL 2005 to Access 2003

Last post 07-01-2009 10:57 AM by Adriaan. 2 replies.
Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 07-01-2009 5:14 AM

    Export tables from SQL 2005 to Access 2003

    Reply Contact

    Hi,

     I have a Table in SQL 2005 with columns having datatype nvarchar(255). When i Export this table to Access the Datatype get changed to Memo.

    However I want the Access datatype to be Text. I tried changing the Datatype at Access level, but it gives me an memory error.

     The machine being used is a Server and is currently not being used by any other major Processes apart from SQL 2005.

    I understand the reason maybe becoz Text in access only stores 255 character and my nvarchar column in SQL stores Unicode data as well.

     Could some one please provide some alternative so that I may export the Data into Text Data type in Access.

     Thanks 
    Filed under:

  • 07-01-2009 10:16 AM In reply to

    • melvinlusk
    • Top 100 Contributor
    • Joined on 11-20-2007
    • Baton Rouge, Louisiana
    • Posts 173

    Re: Export tables from SQL 2005 to Access 2003

    Reply Contact

     

    I guess you could first export it to excel or a flat-file and then to Access from there using a single SSIS package. Confused

  • 07-01-2009 10:57 AM In reply to

    Re: Export tables from SQL 2005 to Access 2003

    Reply Contact

    Could you create the MDB in Access, with the tables and columns, then export to the existing MDB?

    On the Text(255) column, you need to set the "Unicode Compression" property to Yes.
Page 1 of 1 (3 items)
Active Topics   My Discussions    Unanswered Posts


© 2010 Jude O'Kelly All Rights Reserved.