I have a table that has about 250 fields in it, many with text fields where
the sum of bytes for all fields is about 6000. This table is in SQL Server.
I have tried to use DTS to copy this table to Access, but it seem I lose some
of the data in the last field.

Is this possible, or is there something I need to do. I have tried changing
the TransformFlags property of the transform to DTSTransformFlag_Default and
even 191, but still get missing data in several rows. I have tried this on
more than one table, and it seems that it sometimes works. I suspect it has
to do with the table width.

Any ideas on what the problem is or how resolve it?

Thanks in advance,

WayneM

Hello WayneM,

Does "text fields" mean character or TEXT proper?

The max row length as I am sure you are aware is 8060 so there would appear
to be no trouble there.

You say it sometimes works and others not? same data? Are you sure that
your data is not being truncated?

Allan