Linked excel files in access DB as datasource

JanClaes · Post by **JanClaes** » Thu Feb 14, 2008 6:37 am

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!

ray.wurlod · Post by **ray.wurlod** » Thu Feb 14, 2008 3:25 pm

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.

JanClaes · Post by **JanClaes** » Mon Feb 18, 2008 6:34 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:24 pm

Please mark the thread as Resolved.