Macro help in MS Excel to connect to SQL database 1

[PleaseGiveHelp]

I'm pretty new with creating macros and have only created the very simple macros at that. I have an excel spreadsheet that I will get each week (with different data) and I will need to focus on the data in the D$ column. I'll need to create a macro that I can run once I open up this spreadsheet that will look at the D$ column, go to SQL server and run a query (select short_name from account where short_name like [D$ column contents]) and then from there will overwright the D$ column with the results of the query. It will do that for every row. Is this possible? How woudl I go about it?

 

[PleaseGiveHelp]

YOu're the best. I'm nominating you as a valuable poster. I really appreciate all of your help!

 

[SkipVought]

Glad I could help.

You'll find that various contributors have strengths in different areas.

Stick with it and soon you'll be contributing helpful tips, too!

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[PHV]

PleaseGiveHelp, to do what you said, you have to click the star link titled: Thank SkipVought for this valuable post!

 

[PleaseGiveHelp]

That I did! I don't know if they send you an email or how that works but I did do it. I'll do it again.