1. Home
  2. Excel and ODBC

Excel and ODBC

You can access data within an Excel file by specifying an ODBC Data Query connection to an Excel file using the Microsoft Excel (*.xls) ODBC driver. This facility can be used to form SQL queries to import from a single worksheet or merge data from multiple worksheets from the Excel file.

The ODBC driver treats each worksheet as a table in a database and uses the labels in the first row as the column names.

Updated on December 14, 2018

Was this article helpful?