Connecting SQL Server 7.0 and MS-Access

You can connect a MS-Access database to SQL Server as a linked server, and query Access tables in SQL Server’s Query Analyzer. This can help in porting data from Access to SQL Server.

Using a defined JOB in SQL Server, you can almost replicate an Access table into SQL Server at a scheduled time.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: