Microsoft Access tables
The following .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 accessing the Northwind sample Access database. However, this example uses the ACE OLE DB variable.
<ADODSC>
<ConnectionString>
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\Program Files\Microsoft Office\
OFFICE11\SAMPLES\Northwind.mdb;
Persist Security Info=False
</ConnectionString>
<Table>
Sheet1
</Table>
</ADODSC>
See also