DSXchange

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 not recognise the file path.
Anyone out there with an answer?
Thanks!

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.

ray.wurlod wrote: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 see the linked tables
Thanks