Query to export data from Access 2003 to Oracle ?

J

Jeff Boyce

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top