Using the cells to buyild the query

S

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top