New table/form

[shellscott]

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

 

[Van T. Dinh]

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.