EXPERT RESPONSE
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.
|
