If I have a list (excel for ex) of data, How do I use that query data from tables in access

[Russellh]

For example I have 100 customer numbers on a spreadsheet in excel from some report I've run.


In my access database there exists tables that have the customer number as one of their fields and other information that I need..
I need to know what the normal process is for building that query with out a mile long "or" statement in the customer # field that would pull the info I need for just these customer numbers.

So where I would normally make a query and include all the tables and link them up and I would select "customer number" and from Table 1 "address", "phone" and from Table 2 "balance" and so on, and I would pull all the customer information for all customers I just want query this info for only the customer numbers that I have listed on my spreadsheet.

I could create a Temporary Table in the database and upload the 100 customer numbers in it and then link it query design. Then I would change the join to show all the records that exist in the temporary table and only those that match in the other tables.
If that process would work is that the normal method or best practice, keeping in mind I know so little visual basic programming that I wouldn't consider that an option unless it was the only way.

[jwhite]

Do your Customers have a unique CustomerID assigned to them? Please show your table structure and a set of sample records with field name headers.

[Russellh]

[Russellh]

Yes they are unique. So I have the query built above and this is just an example. I may do this for any number of queries or fields. So in addition to this setup I have a list in excel of the 100 customers that I need to pull this query for.
I could put some huge "OR" statement under the "MBRSEP" field. I could also create a TEMP TABLE and upload the "MBERSEPS" in table and then add that table to the query with the join I mentioned to only pull those 100 customers.

Which is the best / preferred practice without VB programming. So I may do this in a totally different query for location information with a list of specific locations. I understand the the data type would have to be the same and in the same format as how its stored in the table.
I just would like to know how to do this for querying in general rather than specific results for one I am doing right now.

[jwhite]

I understand better now. Have you tried to link to the Excel sheet from MS-Access and make a query joining the Excel sheet with your other applicable table(s)?

[Russellh]

No, I'm not sure how to link a spreadsheet. Would that be the normal method to do what I am trying to do?

[aytee111]

To link to an external file, go to the External Data menu/Import & Link. Select the file type - in your case Excel. A wizard will begin, follow the instructions. From there you can treat this the same as any other table, include it in queries etc.