New table/form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table inexcel that I want to be able to type in the part number in
access and it looks up the same part number in excel and returns the current
price & description
 
You can link an Excel spreadsheet as a linked Table in your database and use
the DLookUp() function (or Recordset in code) to retrieve the Price &
Description.

Use the Menu File / Get External Data ... / Link Table ... to link the Excel
spreadsheet to your database.
 
Back
Top