Using Excel Data to create Query Criteria

  • Thread starter Thread starter RisingStar
  • Start date Start date
R

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top