Search Access Table with Excel

[Looch]

Hi All,

I'm new to programming Excel but have been at it for a couple years
now with Access.

Can a macro be written to search an access table using data from an
excel list as criteria? If so can the fields returned in the query
(i.e. select * from table1 where column1 = an excel list value) be
assigned to individual cells in the worksheet?

Just wondering if its possible.

Thanks for any insight.

 

[Guest]

Yes. Use ADO. You would just construct the appropriate SQL string to pass
to the query.

Another way would be to do a querytable. You can create a querytable with
the macro recorder turned on to get the code to create the querytable.

 

[merjet]

There are some examples here:
http://www.erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet

 

[Looch]

Thanks to both, that'll get me going for sure. Thanks again.