If your goal is to periodically import data from Access to SQL Server you can set up and schedule a Data Transformation...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.