423,498 Members | 1,177 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,498 IT Pros & Developers. It's quick & easy.

How to retrive tables from ODBC Connected Database

P: 58
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!
Nov 26 '10 #1
Share this Question
Share on Google+
9 Replies


100+
P: 255
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.
Nov 26 '10 #2

P: 58
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
Nov 26 '10 #3

P: 58
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?
Nov 26 '10 #4

100+
P: 255
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.
Nov 26 '10 #5

P: 58
Yeap, that it works! but how about to import automatically! So my Boss shouldnt have to import it throgh that EXTERNAL DATA-Tab
Nov 26 '10 #6

100+
P: 255
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.
Nov 26 '10 #7

P: 58
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!
Nov 26 '10 #8

100+
P: 255
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.
Nov 26 '10 #9

P: 58
Shoul there be no more alternatives for this, I will!
Thanks
Nov 26 '10 #10

Post your reply

Sign in to post your reply or Sign up for a free account.