It is assumed that you have already installed and configured a DSN for ODBC driver for SQL Server. Devart ODBC drivers support all modern versions of Access.
In Microsoft Access, you can connect to your SQL Server data either by importing it or creating a table that links to the data. Access can be used as a substitution for spreadsheet applications like Excel to organize, store, and retrieve large amounts of related data that can be difficult to manage in spreadsheets. Microsoft Access is a dababase management system that combines the relational database engine with a graphical user interface. This article explains how to connect Microsoft Access to SQL Server through the standard ODBC interface. Connecting Microsoft Access to SQL Server Using an ODBC Driver
0 kommentar(er)
