![]() |
Using the cells to buyild the query
I have a sheet that contains a list of UPC I want to query the
database and build this report using excel. The report is simple but is driven off of the list of UPCs is their a way I can write this without a lot of VBA work? I was hoping that by the time Excel 2003 came out that SQLwould be able to interact with cells Something like Select * FROM Product WHERE UPC11 IN(=IN('Product List'!A:A)) or something simple like that It has been about 5 years since I have touched VBA so I would prefer an alternative approach. |
All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com