Ask the Expert

Extracting data from Access using SQL Server

How do I extract data from an Access database using SQL Server?

    Requires Free Membership to View

If your goal is to periodically import data from Access to SQL Server you can set up and schedule a Data Transformation Services (DTS) package to do the extraction. If you have queries that rely on data from SQL Server and Access, you can set up the Access database as a linked server.

Both searchDatabase.com and SQL Server Magazine have good articles and tips on DTS. Search the SQL Server Books On Line index for "linked servers" for more information on configuring and using a linked server.

This was first published in July 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: