General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Dear All,
I won't ask if it is possible because there is always a way. How do I use values from an Excel 2003 file to supply criteria to an Access 2003 selection query?
I have a query that returns all the open accounts payable transactions. I want the query to only return records for certain vendor ID numbers. I have a list of the vendor ID numbers in Excel. How do I tell Access to run the selection query and return the records only for the vendor ID numbers listed in an Excel file? The ID numbers are subject to change, are not sorted in any particular order, and the count of ID numbers may change.
Thanks to all,
GL
I won't ask if it is possible because there is always a way. How do I use values from an Excel 2003 file to supply criteria to an Access 2003 selection query?
I have a query that returns all the open accounts payable transactions. I want the query to only return records for certain vendor ID numbers. I have a list of the vendor ID numbers in Excel. How do I tell Access to run the selection query and return the records only for the vendor ID numbers listed in an Excel file? The ID numbers are subject to change, are not sorted in any particular order, and the count of ID numbers may change.
Thanks to all,
GL