Multiple Criteria in query

[tpeter]

I have an Excel 2003 file with 12,300 records from a customer. I need to
compare the badge numbers in my Excel file and find the matches in my In
house Access 2003 database, 1,100,000 records to match up data. If I put the
badge number in a Access query in works but I can only put in 9 badge
numbers. Is there a better way to do this, any suggestions would be great.

Thanks for your help

Tim Peter

 

[Jerry Whittle]

You could use a subquery instead. Something like:

SELECT BadgeNo
FROM AccessTable
WHERE BadgeNo IN (SELECT Distinct BadgeNo
FROM Excel ) ;

It might be slow.

 

[tpeter]

Thanks Jerry,

I haven't tried it yet. I imported my excel file into Access and then ran a
join query showing all records from excel (while merging the 4 fields from
Access) and only those that matched the badge number in access to join the
addtional data that was in the Access file. Waiting on approval from the
bosses but I think this will work. If it doesn't then I will try your code. I
appreciate your help on this.