Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Using linked tables in Access (Read 3605 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Using linked tables in Access
04.10.06 at 11:59:03
Using linked tables in Access
Linked tables can be queried in an Access database.  
Linked tables are external tables to Access that are coupled through ODBC or direct file connections. The tables are listen in the tables list in Access.  
To query these tables with SQL*XL you can simply connect from Excel to the Access database and do a select * from linked_table_name. Note that the linked tables do not show up in the tables or views list in the SQL*XL SQL editor. Despite not being listed they are available!
Note that you may have to provide the password to access the linked table if it is linked through ODBC in Access. You can save the password in Access but when this is not done you may need to type the password again.
General information about SQL*XL:
Back to top
« Last Edit: 04.10.06 at 12:00:00 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1