I have a few access databases at work and i linked into one of them via
dataimport external datanew database query. This allowed me to select
a pre built access query to pull in data.
Ive found when trying to access some other access databases that it
will show me the tables and quer's but when i click the + sign to view
the available fields it wont present them it just changes the + to a -
Ive attached a acreen print as an example of when it does work to give
an idea of what im trying to eplain.
+-------------------------------------------------------------------+
|Filename: wizard.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=4418 |
+-------------------------------------------------------------------+
--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread:
http://www.excelforum.com/showthread...hreadid=519152