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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.