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
|