View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Update Excel Column Data from SQL Fields

hi
i would suggest setting up a MS Query and tie the refresh to your button.
or there is a refresh icon on the external data toolbar that could be used
also.
on the menu bar....
dataimport external datanew database query.
follow the wizard.

regards
FSt1

"Ryan H" wrote:

I have a spreadsheet that contains part numbers (Col. A), description (Col.
B), and cost (Col. C). I would like to click a button and the descriptions
and costs of each part number will be updated automatically from the SQL
Database. What would be the best way to go about doing this?

Thanks in advance!
--
Cheers,
Ryan