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
LVL 66
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAsked:
Who is Participating?
 
Patrick MatthewsCommented:
Hello jim,

Is this a one-off task, or does it have to be repeatable?

I'm thinking, just copy the Access db, and run the upsize wizard on it if it's a one-off...

Regards,

Patrick
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
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
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Yes this is a one-off, and the SQL Upsizing Wizard worked great.  

Thanks.
Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.