Monday, March 26, 2012

Memo fields from Access is empty in SQL Server

Hi
I have a DTS packet where I import data from a Access database to SQL Server.
But when I try to import data in memo fields in Access to a nvarchar field in a table on SQL server, there is no data imported.
Anyone know how to solve this problem?Not positive on this one, but I would try to map a memo field in access to a TEXT field in SQL. It should be pretty straightforward to test.

Regards,

Hugh Scott

No comments:

Post a Comment