Connection strings Examples for Excel 2007

.NET Framework 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:

   




ACE OLEDB 12.0

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

Xlsx files:

   
    Note: HDR=YES indicates that the first row containts column name.

Treating data as text:


    All data in the file will be treated as text. When querying data into a result set if you want to include the header row use HDR=NO.
    Remember to user the option IMEX=1 to avoid the application from crashing.

Xlsb files

    Querying Excel file with macro enabled

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