Microsoft Excel worksheets
The following .adoinfo file uses the Microsoft OLE DB Provider for ODBC Drivers and the ODBC data source called Excel Files to read the Sheet1 worksheet in an Excel file called C:\samples\MyMuseumData.xls:
<ADODSC>
<ConnectionString>
DSN=Excel Files;
DBQ=
C:\samples\MyMuseumData.xls;
DriverId=790;
MaxBufferSize=2048;
PageTimeout=5
</ConnectionString>
<Table>
Sheet1
</Table>
</ADODSC>
Depending on the version of Excel that you are using, you might have to put $ (dollar sign) after the worksheet (“table”) name to read the worksheet successfully. In this example, the table name is Sheet1$.
The following example that reads the Sheet1 worksheet in C:\samples\MyMuseumData.xls. However, this example uses the ACE OLE DB Provider.
<ADODSC>
<ConnectionString>
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\samples\myMuseumData.xls;
Extended Properties='Excel 12.0;HDR=YES;IMEX=1';
Persist Security Info=False
</ConnectionString>
<Table>
Sheet1
</Table>
</ADODSC>
See also