sql server dts:

Does anything show up in the import errors tables in Access? are you
importing into existing tables or into empty work tables? If the
former, consider the latter. Also, be aware that some versions of
Access/Jet don't support exactly the same ranges of data and data
types, so if a record is out of bounds, it may not show up. Although
mostly that happens going the other way with date/time bc Jet supports
a wider range of dt values.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Fri, 13 Feb 2004 13:36:08 -0800, Brian Brooks
[quoted text, click to view]