Excel 2007 Query Tool Question about Criteria
Posted on 2011-09-23
I have a question. I know Excel has a built in query tool. I've been able to use it with an ODBC connection to my iSeries. My question is, let's say that I have an Excel spreadsheet with a list of customer ID numbers on it and I want to do a query, using Microsoft Query, to obtain addresses for those customer ID's. Is there a way ti set a criteria to only show those addresses where the customer ID's match from my original Excel file to our master file on our server?