Using Excel Data to create Query Criteria

[RisingStar]

I am using excel for managing data and want to import data from Access. I
need to extract more than 1000 records from Access into Excel. The unique
identifier is in a single Excel column. Is it possible to directly import
this column into access query in the criterion column and then extract the
data?

Many thanks for your help

Risingstar

 

[[MVP] S. Clark]

You can import/link the data from Excel to Access, where the queries are,
then perform the query, then export that data to Excel.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-