Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    10

    Unanswered: 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?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •