Search Access Table with Excel
 

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.

Search Access Table with Excel
 

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.

--
Regards,
Tom Ogilvy


"Looch" wrote:

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.

Search Access Table with Excel
 

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

Hth,
Merjet

Search Access Table with Excel
 

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