Toad World® Forums

Import Access query into an Oracle table


#1

Hi,
is it possible to automatically import MS Access query results into an Oracle Table?
The import function in Automation, lets me import from a text ,excel file or other type of files but I do not see the option to get into Access and select the required query for importing or transferring data from access into TDA-oracle connection.


#2

.


#3

This is a two step process. Query Access and export the data. Then Import into database table of your choice.

Debbie