DSXchange

Welcome aboard. You need to set up an ODBC DSN (Excel driver) with the pathname of the worksheet. When importing table definitions you must check the System Tables check box; for some reason best known to Microsoft, Excel worksheets are presented to the ODBC driver as system tables. It works! I can...

Is it possible to use linked excel files (in Access DB) as a datasource?When I try to import the metadata via ODBC, I cannot see the linked files. Then, I defined the table myself, and then try to connect with the user defined SQL option in the ODBC stage, but I get the message that the system do no...