Microsoft Excel ODBC Driver connection strings

Connects to

Excel 97

  • Standard

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

    SQL syntax "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]". I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.

  • Specify ReadOnly

    [Microsoft][ODBC Excel Driver] Operation must use an updateable query. Use this connection string to avoid the error.

    Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\MyExcel.xls;ReadOnly=0;

    ReadOnly = 0 specifies the connection to be updateable.

Problems connecting?
Get answer in the Excel 97 Q & A forum

Excel 2000

  • Standard

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

    SQL syntax "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]". I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.

  • Specify ReadOnly

    [Microsoft][ODBC Excel Driver] Operation must use an updateable query. Use this connection string to avoid the error.

    Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\MyExcel.xls;ReadOnly=0;

    ReadOnly = 0 specifies the connection to be updateable.

Excel 2002

  • Standard

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

    SQL syntax "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]". I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.

  • Specify ReadOnly

    [Microsoft][ODBC Excel Driver] Operation must use an updateable query. Use this connection string to avoid the error.

    Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\MyExcel.xls;ReadOnly=0;

    ReadOnly = 0 specifies the connection to be updateable.

Excel 2003

  • Standard

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

    SQL syntax "SELECT [Column Name One], [Column Name Two] FROM [Sheet One$]". I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.

  • Specify ReadOnly

    [Microsoft][ODBC Excel Driver] Operation must use an updateable query. Use this connection string to avoid the error.

    Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\MyExcel.xls;ReadOnly=0;

    ReadOnly = 0 specifies the connection to be updateable.

ODBC DriverDriver={Microsoft Excel Driver (*.xls)}Info and driver downloads

Articlesread all »

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.