It is the only way short of rolling your own. DTS can only take Structure +
data.

http://www.microsoft.com/AccessDev/Articles/autqa.htm
http://support.microsoft.com/default...NoWebContent=1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"maxf" <ljp007 (AT) hotmail (DOT) com> wrote

types, etc...) and the data from Access to SQL server. I know there's a
migration wizard in Access but am not sure if this is the best route, or
even works. If anyone knows of a good article or description of the process,
I would appreciate it.