Originally Posted by
JoeM
OK, I don't think you understand what I am trying to tell you, so let me try again.
You have some huge table in SQL that has all your data, and you are trying to select data from based on a list of about 5000 PO numbers. You are trying to create a pass-through query to extract the records you needs (and you need to include these 5000 PO numbers in your criteria). We do NOT need to do anything with this existing SQL data table. Here is what I am proposing:
1. Create a brand-new single-field table in your SQL database. The field should be named something like "PO Number".
2. Once you have created this new table, link this table into your Access database (at this point, it should have zero records in it).
3. Link your Excel table with your PO numbers into Access also.
4. Create an Access Append Query that writes the PO Numbers from the linked-Excel table to the new linked-SQL table you created in step #1 (yes, you can use Access to import records into a SQL table).
5. Update your Pass-Through query so that it links your main SQL data table to this new single-record SQL table that lists all the PO Number you want. By linking these two SQL tables on the "PO Number" field, they query will only return the matching records you want.
Make sense?