PDA

View Full Version : Relate 2 Tables in Excel Database



joprotus
09-02-2007, 02:30 AM
I have 2 worksheets as database in Excel. Can I use a query command to retrieve related information from the two worksheets?:help

Bob Phillips
09-02-2007, 03:06 AM
If you use named ranges for each data set on each sheet, you can use ADO woith SQL. See the thread in SQl for more details.

Bob Phillips
09-02-2007, 03:06 AM
If you use named ranges for each data set on each sheet, you can use ADO woith SQL. See the thread in SQL forum http://vbaexpress.com/forum/showthread.php?t=14661 for more details.

joprotus
09-05-2007, 12:33 AM
Thanks.