View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jgrebe jgrebe is offline
external usenet poster
 
Posts: 1
Default Link to SQL Database

I need to link to a sql database to return a value based on my excel
spreadsheet. I have an inventory item number on my excel spreadsheet and I
need to return the inventory price field from my Inventory Master table in
SQL. I have several items on my spreadsheet so I need a way to have the
lookup for each inventory item.

Thanks in advance.