DTS: Import ALL tables from Access.mdb to SQL db

Posted on 2007-10-11
Last Modified: 2013-11-30
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.

Question by:Jim Horn
    LVL 16

    Expert Comment

    LVL 65

    Author Comment

    by:Jim Horn
    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
    LVL 92

    Accepted Solution

    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...


    LVL 65

    Author Comment

    by:Jim Horn
    Yes this is a one-off, and the SQL Upsizing Wizard worked great.  


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now