Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set time to update from unix table to MSAccess

Status
Not open for further replies.
Nov 17, 2003
105
GB
I have an imported (Unix ODBC link) table which i need to AUTO update (nightly)I do not know how to do this.

This allows our sales team to run a quicker sales order query and obtain reports i have written in MSAccess. Our legacy unix system currently runs the reports via a download into Informix. I have adjusted these sql reports before, but find access provides better presentation. Could anyone help please.
TIA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top