Jim Horn
asked on
DTS: Import ALL tables from Access.mdb to SQL db
Hi All
Is there a way in DTS (or anything else) to import ALL tables from an Access database into a SQL db in one task?
I'm currently using the DTS 'Transform Data Task' to import tables individually, and as you can imagine this is getting somewhat redundant.
TIA
-Jim
Is there a way in DTS (or anything else) to import ALL tables from an Access database into a SQL db in one task?
I'm currently using the DTS 'Transform Data Task' to import tables individually, and as you can imagine this is getting somewhat redundant.
TIA
-Jim
ASKER
I'm running SQL2K, and this appears to be SQL 2005. Is there an alternate solution for SQL2K?
I downloaded the .msi, and now it's stating that it requires Microsoft J#.NET Redistributable Package v2.0.50727
I downloaded the .msi, and now it's stating that it requires Microsoft J#.NET Redistributable Package v2.0.50727
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes this is a one-off, and the SQL Upsizing Wizard worked great.
Thanks.
Jim
Thanks.
Jim
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en