SQL with Excel ranges

A

Arshavir Grigorian

Hi,

I would like to be able to select a set of Excel cells, name them,
then write VBA code to filter the range based on certain criteria -
essentially treat the range as a database table and run an SQL on it
returning a set of rows that match the criteria (the SQL WHERE
clause). Is it possible to do such a thing and if so how should I go
about coding it? DAO? I think I can simply loop through the range and
filter rows through an IF() statement, but I am thinking there is a
better way ...

Thanks.
 

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

Similar Threads

Macro needs updated Range name addresses 3
Using named ranges in macro 6
SQL not importing records from ACCDB 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Filter, Delete and Error handling - need help 4
Automatically create ranges and then name them 6
Open a word mail-merge document from Excel VBA 1
Array as Source for List Box 4

Top