Copy data from Oracle to MS Access

[desi5pure]

Does anyone know how to copy data from Oracle tables to MS Access tables (with same name) without copying to MS Excel first?

 

[Remou]

It is possible to link Oracle tables to Access and from there a make table query should work.

 

[desi5pure]

I know I can link Oracle to MS Access using ODBC and view data but I want to copy data to MS Access so I can use MS Access even when link to Oracle server is down.

 

[dhookom]

What about Remou's suggestion won't work for you?

Duane
Hook'D on Access
MS Access MVP

 

[sxschech]

If you want to actually copy the data locally, you can write a make table query off of the odbc linked table or off of a pass-thru query.

 

[psimonnyco]

Another obvious one: save the Oracle table as a .csv and then import it into Access. You can then just import the table if you like.

 

[desi5pure]

Thanks!

 

[nim180]

There are a number of free programs out there that does it for you just type it into google.

Nim