Provider=.12.0 Data Source= C:\MyData\myExcel2010file.xlsx Extended Properties='Excel 14.0 HDR=NO' (Microsoft ACE must be installed use it for Excel 2010 files)ĭriver= DBQ= C:\MyData\MyExcelFile.xlsx (Microsoft Excel 2007 ODBC Driver must be installed)Ģ. Provider=.12.0 Data Source= C:\MyData\myExcel2007file.xlsx Extended Properties='Excel 12.0 HDR=YES' (Microsoft ACE must be installed use it for Excel 2007 files) Here are basic connection strings (more examples and details can be found in the Internet): This way is very flexible and allows to specify many additional parameters in the connection string and override standard Database Tour connection behavior. Select ADO interface, then choose Connection string option and write a connection string.
