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
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...
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...