Import and Export Data tool bug

Hi,

I'm tring to import an Access database to a MsSQL Server 2000 SP4 using Import and Export Data tool which comes with SQL server 2000. After the import finishes with result: "Success", I saw that there are records which aren't exported. These records type is Memo in the Access database. But some of them are filed in others aren't. Is there a fix for this? Is there another way to import this records? Using TSQL?

Thanks guys.

Hi,

another option would be to setup a linked server for the access database and to normal TSQL statements to insert the data from the access database to SQL Server tables.

There are samples in the BOL how setting up a linked server for Access.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de