I have a bunch of part numbers in Excel. The prices for each of the part number are located in a separate database accessible via the Internet. Is it possible to have the Excel spreadsheet access the prices? Ideally, there would be some function like =getSoap("http://somesite.com","data","password") which would automatically update to display the price. If so, what is the preferred protocol? I am thinking of maybe SOAP or something similar.

Thank you