export data from SQL 2000 to Access 2002

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

Hello,

I tried to export a table from SQL 2000 to Access 2002.
Everything works fine except data in one field can not be
exported. I did check datatype(char) and size and they are
all correct. There are several fields with same property
and they are exported correctly. Also I did preview the
data during before transferring data in SQL 2000 and data
was there. Does anyone have an idea what I did wrong?

Thanks.

Jane
 
How did you do this export?
What tools did you use?

A simple char field should easily export to Access.
 
I exported it in EM of SQL 2000. There are 8 char fields
with size of 255 each. After I tested it using ODBC drive,
it showed me error message that said that the record is
too large. So I changed varchar (in DTS, it convert char
to varchar automatically) to longtext which is a memo
field in Access. Now every data has been exported.

Thanks so much!
 
Back
Top