How do you extract data from Access to SQL?

    Requires Free Membership to View

This is a common task. Based on the information, my recommendation would be Data Transformation Services that ships for free with SQL Server. Here are URLs I would recommend taking a look at for more information:

DTS overview

DTS Import/Export Wizard

Creating a DTS package with the DTS Import/Export Wizard

Good luck!


Do you have comments on this Ask the Expert Q&A;? Let us know.

This was first published in June 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.