Import external tables

[mark curtis]

Dear all,

I need to import three tables/views from an Oracle database. I know that the first thing you are saying "Why don't you just set up an ODBC connection and link the tables for online live data?" I agree this is the way but my database is an mde which many people use and if they try to get data from the linked ODBC and their regedit,tnsmanes.ora etc have not been changed then they get errors. Therefore I just want to programmatically import three tables perhaps on the click of a command button.

A challenge??

Thanks
Mark

 

[Nero]

You could try creating three blank tables and running an append query to import the data .

 

[mark curtis]

Nero,

How would the append query know where to get the Oracle views from?

Thanks
Mark

 

[Pat Hartman]

If they cannot access the Oracle tables directly via an ODBC linked table because of a PC setup issue, then there is no way for them to import the tables because there will still be an ODBC issue.

 

[mark curtis]

Pat,

I can access the views via ODBC ok but I just want to import the views using ODBC and not link to the views.

Basically I want to use the ODBC to connect, import the views then disconnect.

Thanks
Mark

 

[Pat Hartman]

Your reason for wanting to import rather than link is "if they try to get data from the linked ODBC and their regedit,tnsmanes.ora etc have not been changed then they get errors". If they can't reference the linked tables because their ODBC connection is not set up properly, what makes you think that the ODBC connection will work so that they can reference views to import them?

To import the views, treat them as tables. Link to the view and use a make-table query to copy it into an Access table.