VBA in Excel to extract data from Access

[msquared99]

First off I am new to using Access but am pretty good with Excel and VBA.

The scenario is I have a Access database setup where I have several tables linked to a query. The query filters the data to what I need. What I would like to do is have a user be able to enter say a company ID number in an Excel User Form, have VBA search the Access query and return only the data associated with the company ID. The database has well over 200k records.

I know how to connect to the database in VBA but it is the searching of the query I'm not familiar with.

Any other suggestions or help would be greatly appreciated.

Thanks,

Mike

[msquared99]

I was able to solve my delima by using the code at this link: http://datapigtechnologies.com/blog/index.php/running-an-access-parameter-query-from-excel/

[SamT]

:thumb