Connect to Excel

How can i connect to an Excel file?

I try this: create table Customer engine=connect table_type=ODBC tabname='Sheet1' Connection='DSN=ExcelDSN;DBQ=C:/Test/test.xls;';

I get always get the message: SQL Fehler (1105): [Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht Übereinstimmende Architektur von Treiber und Anwendung auf.


If you search for this error you will find lots of pages that explain what it means and how to fix it. You probably have 32-bit MariaDB and 64-bit ODBC driver, or the other way around.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.