[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 697
  • Last Modified:

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
0
Jim Horn
Asked:
Jim Horn
  • 2
1 Solution
 
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
 
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:
Yes this is a one-off, and the SQL Upsizing Wizard worked great.  

Thanks.
Jim
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now