Toad World® Forums

Import Access query into an Oracle table


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.




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