Is it possible to run a SQL "Select...Into" from Access against an Oracle database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm using Access 2002 with Win 2000

Is it possible to run a SQL "Select...Into" from Access against an Oracle database wherein a table is created in Access that contains the data retrieved

This would be a huge help for making data repositories on the fly (something I need to do often)

If this is possible could someone please post example SQL. If not is there a good alternative method (again please post example code) for adding an Access table based on a query?

Thanks very much in advance for the assistance
 
Rotor,

Link your table(s) in Oracle to your Access database via
an ODBC connection just like you would link tables
between access databases.

Then write your query just as you normally would.

Mark
-----Original Message-----
Hello, I'm using Access 2002 with Win 2000.

Is it possible to run a SQL "Select...Into" from Access
Click to expand...
against an Oracle database wherein a table is created in
Access that contains the data retrieved?
This would be a huge help for making data repositories
Click to expand...
on the fly (something I need to do often).
If this is possible could someone please post example
Click to expand...
SQL. If not is there a good alternative method (again
please post example code) for adding an Access table
based on a query?
 
Back
Top