Need to import an Oracle db into MS Access

[rjurgens]

I am trying to import an Oracle table,
believe it is version 8.1, into MS Access 2000.
What I want to do is let the user import this table
at anytime by clicking a button. I do not what to
make it more complex to them than that.
Any suggestions?

 

[luceze]

Would'nt it be easier to link to the table via ODBC?

Eric

 

[rjurgens]

We bring down the system alot during the testing phase so they are not up for about 10% of the time. So no, unfortunately.

 

[luceze]

If the system isn't up then how will they have access to the table to import it?
You could link to the table and then run a make table query to import it to the current database.

Something like this would work.

strsql="SELECT YourTableName.* INTO NewTableName FROM YourTable;"
docmd.runsql strsql

HTH,
Eric