Query to export data from Access 2003 to Oracle ?

  • Thread starter Thread starter Luqman
  • Start date Start date
Luqman

You haven't indicated whether you are preparing data to be sent to, and
uploaded by, an Oracle database, or if you are already connected to the
tables in an Oracle database.

If the former, write your query to extract the desired data. Then, with the
query name highlighted in the Query tab of the Database Window, select File
| Export and a form/format in which you wish to export to another file.

If the latter, you can build your query to update (or append to) one/more
Oracle tables you have linked to your Access database.
 
Back
Top