Toad World® Forums

connecting 2 excel files


#1

i remember being able to connect multiple excel files and running querys on them in the 1 version! how can i connect 2 excel files and sun some queries on them ???


#2

Unfortunately, this has never been able to be done. You can not perform a heterogamous query on two excel files. It would need to be one excel file and one other type of database, Oracle, DB2, etc. Perhaps you import one of the files to another database type, Access maybe?


#3

What if you merged the data into a single file? You should be able to query across datasheets, which Toad sees as tables I think.