Connection strings for Excel - Connectionstring Examples

Connection strings Examples for Excel

.NET Data Provider for OLE DB

This is a .NET Class Library from Microsoft. The namespace for this provider is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\yourExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Microsoft Jet OLE DB 4.0

This is an OLE DB data provider from Microsoft. The usage for this provider is Provider=Microsoft.Jet.OLEDB.4.0.

Standard Security:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\yourExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

OR

OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\yourExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

Note: The quota " in the string needs to be escaped using your language specific escape syntax.

Microsoft Excel ODBC Driver

This is an ODBC driver from Microsoft. The usage for this provider is Driver={Microsoft Excel Driver (*.xls)}.

Standard Security:

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\data\yourExcelFile.xls;DefaultDir=c:\data\yourPath;