Data Model > Available DSCs > ADO DSC > Example .adoinfo files > Microsoft Access tables
 
Microsoft Access tables
This .adoinfo file uses the Microsoft OLE DB Provider for ODBC Drivers and the ODBC data source called MS Access Database to read the Employees table in the Northwind sample Access database:
<ADODSC>
<ConnectionString>
DSN=MS Access Database;
DBQ=C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;
DriverId=281;
FIL=MS Access;
MaxBufferSize=2048;
PageTimeout=5;
UID=admin
</ConnectionString>
<Table>
Employees
</Table>
</ADODSC>
Here is another example that reads the Employees table in the Northwind sample Access database. However, this example uses the Microsoft Jet 4.0 OLE DB Provider. Generally, it is preferable to read Access data using the Microsoft OLE DB Provider for ODBC Drivers because it will return variables in the order specified in the SQL query (or in the original order in the input data source if no query is specified), whereas the Jet provider always returns variables in alphabetical order.
<ADODSC>
<ConnectionString>
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;
Persist Security Info=False
</ConnectionString>
<Table>
Employees
</Table>
</ADODSC>
See also
Example .adoinfo files