how to use an excel file to make multiple searches in Access database

[aquoica]

Hi, I am new here.


I have an auto parts database with parts numbers, names and other details saved in MS Access. I only know how to search by parts number one at a time to retrieve the detail of the particular parts. But I always receive enquiry from customer in Excel file with a list of auto parts numbers that I need to reply. Since these lists always contain hundreds or more parts numbers and it consumes a lot of my time in searching it one by one in Access and typing the result manually into the Excel file and send it back to customer.


My question is, Is there a easier way for me to finish the job, says, make multiple enter/search in Access and export the result to Excel file, or is that a miracle that I can match the Excel File into the Access and let them do the job automatically and have all the data matching.


Hope I can get good news here.


Thanks

 

[bobhc]

Good day aquoica


Link your Excel sheet into Access then do a query between customer’s requirements and parts table and the query will show parts data to match customer list.

 

[aquoica]

Hi bobhc,


Thank you for your useful answer. As I am a id on Excel and Access, so, do you mind tell me more details on how to link up Excel sheet into Access and how to set the query table. What format will be the matching result and will it possible to export it out.

My Customer Excel sheet only have a list of parts number, i.e

12345

23456

34567

45678

and my Access database have the details of those parts number, i.e

Parts number, description, price, inventory level..etc.

Thank you once again

 

[NARAYANK991]

Hi ,


Rather than just answer your question , here are some links which will tell you all you need to know to do it yourself. In the long run , it may be better to learn about interfacing these two software packages , since it can improve your productivity substantially.


http://www.datawright.com.au/excel_resources/excel_access_and_ado.htm


http://www.excel-spreadsheet.com/vba/dao_ado.htm


http://www.erlandsendata.no/english/index.php?t=envbadac


http://msdn.microsoft.com/en-us/library/aa260804(v=vs.60).aspx


Narayan

 

[bobhc]

aquoica


if you put this into Google you will get many links, also some videos that may be of use. "how to make an access query" no quotes

 

[bobhc]

This series of Access videos will get you going


http://www.youtube.com/playlist?list=PL4DD96CF7EF8C1955

 

[aquoica]

Hi Narayank991 and Bobhc,


Thanks so much for all your recommandations and links, I am working on that and hope I can master some of the technique of both softwares.


Thanks again