How to retrive tables from ODBC Connected Database

[Moah Scout]

Hi all!
I have a database which is connected to another db by ODBC Connection string via VBA. What I want is to have those tables succesfully connected through ODBC be accessible in my db-NavigationPane as tables or whatever the type.
Currently I can view the ObjectNames in the VBA only and not in my Access DB
Please help!

[colintis]

You can create an external linked table with the integrated function within Access [External Data]-->[ODBC database]. Then best select "Link to the data source by creating a linked table", in case if there's updates. Then select the database type and the instructions come up and you'll be there just fine.

[Moah Scout]

Thanks for your imediate response!
But when trying to connect it gives the following errors.

You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. (Error 3423)

You are attempting to link, import data from, or export data to either an external Microsoft Access database engine table or an external ISAM database table (for example, dBASE, Microsoft FoxPro, Paradox, or Btrieve), but you have selected <SQL Database> as the data source. You must select the appropriate data source for the data you are attempting to link.
Actually I havebeen trying to connect to Excell2007 sheets

[Moah Scout]

But I can still import this database through [External Link] in my access db. The thing is my users dont know even how to import they just wanna see the results their imported automatically!
How could this be achieved through VBA or else?

[colintis]

If your target file is an Excel sheet, then you should click the "Excel" button in the external data instead of ODBC connection. Its more straight forward and remember always select "Link to the data source by creating a linked table" for frequent updates on the excel file.

[Moah Scout]

Yeap, that it works! but how about to import automatically! So my Boss shouldnt have to import it throgh that EXTERNAL DATA-Tab

[colintis]

As I said earlier, if you import the file as a link table, the update will be done automatically when you open it. Link table is different from import table, it simply makes a connection between the file, data are not actually stored into the Access database, where it directly reads the excel file for data instead.

[Moah Scout]

Yeah!
If all users gonna use the same table`sName as I imported before! But in actual sense the users will need to import a new tablesName of their own choises.
How to make this Automatic even by using macro!

[colintis]

If that's their current "actual sense", then brain wash them to change that manner of doing that.

Unless you are telling me that file with the same name contains different information in each individual user's computer....and that, will be end of discussion in this post, back to another one where you posted the codes.

[Moah Scout]

Shoul there be no more alternatives for this, I will!
Thanks