Hello,
I have an Excel file with 1000 lines of Information. I would like to link this file to MS Access and have one windows wherein it will ask user to enter Product ID/ or Product Type/ or Supplier Name. If the information is found it should be displayed with the complete Row details from Excel file.
Can someone guide me how to build the table, query and report as I am a beginner in MS Access.
Thanks and regards,