469,271 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

How to retrive tables from ODBC Connected Database

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
9 7760
colintis
255 100+
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
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
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
colintis
255 100+
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
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
colintis
255 100+
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
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
colintis
255 100+
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
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.

Similar topics

6 posts views Thread by sparks | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.