Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close