Discussion Locked

Use a Microsoft Query in Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using a program called USQL to connect to a RS6000 to retriev data. Right now the way I am suppose to do it is to Use Excell and get data then use Microsoft Query to get the data using the data connection created with USQL. Then Microsoft Query returns the data to Excell. I then import the Excell into Access to run my report. How can I connect or link an Access table to either the Microsoft Query or the data connection. If I goto get "External Data" then choose either Import or link in Access I can choose for a file type ODBC Database Then choose my data connection but nothing appears to happen.

3 replies

by donq

Microsoft Access 97 and 2000 is a stand alone product containing two database engines. It also has its own query builder where DAO coded queries link with an Access Table and/or an ADO coded query links to SQL-Server, Oracle, Informix, or whatever. When one uses the Access Query buildes all connectivity is aytomated, and error checking is accomplished as the query is being constructed.

You must contact USQL and/or RS6000 for the answer as stand alone access works fine automatically linkingall data sources???

This discussion is closed to new replies.