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

 

[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