export data from SQL 2000 to Access 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jane - 31 Aug 2004 18:21 GMT

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

Reply to this Message

Joe Fallon - 02 Sep 2004 02:17 GMT

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

A simple char field should easily export to Access.

Signature

Joe Fallon
Access MVP

> Hello,
>
[quoted text clipped - 9 lines]
>
> Jane

Reply to this Message

Jane - 02 Sep 2004 13:24 GMT

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!

>-----Original Message-----
>How did you do this export?
[quoted text clipped - 16 lines]
>
>.

Reply to this Message