I connected to a MS Access 2002-2003 format through TOAD for Data Analysts. However, I cannot view all the existing queries from the Access DB as SQL statement in SQL Editor.
Currently, I have to cut and paste the SQL from Access into TOAD SQL Editor and perform “SAVE AS”. This process is too tedious especially when there are 60+ queries.
I am looking for a smart way to accomplish this vs. poor man approach (cut & paste).