Hi

Can anybody advise me on how to import tables from an Oracle database into Access 97?

In addition to Access 97 I have a copy of SQL+ but don't now how to use it as yet.

Regards

Ian

You need to install the Oracle client.
You need to make sure the Oracle server is defined in the Oracle client.
You need to make sure you have some kind of permissions to access the data on the Oracle DB.
Then you can setup an ODBC connection or use OLEDB (I perfer the ODBC route, but either works).
Then you can either linkt he table/s or better write a passthrough query you can use to do a MakeTable from or append data to an existing table. Passthrough queries offer the advantage of perfomring selection, grouping, etc on the database (Oracle) side rather than in the Access side.

Thank you for the info

I have managed to connect using ODBC and can import the tables I need from the Oracle db.

I am having difficulty with a pass through query.

I can write the SQL to select the data from the table in the Oracle db but don't know how to end up with this data in a new table.

Can you help on this?

Regards

Ian B