By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Refreshing ODBC Data

P: 8
Hi all,

I am trying to set up a program to pulls information from a Unix server via an ODBC connection and into an Access table. I have set up the systen DSN and I am able to manually import a database from the Unix server into Access.

The database on the Unix server will be updating daily so I need a way of automatically querying the Unix database and updating the new data into the Access table. Would I need to write some VB script to do this?

Unfortunately I still pretty new to Access so I hope this makes sense.

Thanks!!
Jan 17 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
If you have a System DSN then you should be set up and ready to link the remote table into your Access database. This leaves you with what is essentially a live link across to the back-end table.
Jan 18 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Go to Get External Data on the file menu and select Link Tables rather than import. When the file browser window opens change the 'files of type' option to odbc databases and the odbc wizard should open.

Mary
Jan 18 '07 #3

Post your reply

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