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.
--
Joe Fallon
Access MVP



"Jane" <(E-Mail Removed)> wrote in message
news:389301c48f7f$055372b0$(E-Mail Removed)...
> 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

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?
>What tools did you use?
>
>A simple char field should easily export to Access.
>--
>Joe Fallon
>Access MVP
>
>
>
>"Jane" <(E-Mail Removed)> wrote in
message
>news:389301c48f7f$055372b0$(E-Mail Removed)...
>> 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
>
>
>.
>