Q

Extract data from Access to SQL

How do you extract data from Access to SQL?
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

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close