Export Access Memo field to SQL Text field

Hi,

Can anyone point me any solution how to export a MEMO field from an Access database to a TEXT field from an MS SQL Server 2000. The import export tool from SQL server doesn't import these fields if they are very large - around 9000 characters.

Thanks.

You can use the TEXTCOPY utility in SQL Server 2000. You can find it in the BINN directory of the server instance. This is a DBLIB utility to import a single text/ntext/image value into a row. You can also use BCP to import the data.