This can drive you mad!!

Try recording a macro while using the menu options Data-Import External
Data and using the appropriate connections etc. It should give you a
starter template if not the whole answer.

--
Cheers
Nigel



"Carl" wrote in message
news:t7Hcf.65$7B.48@fed1read02...
Does anyone have samle code to connect and run a stored Proc on SQL
Server?
I have the Server name. It is added to my ODBC and connection is good, but
to simply connect and run a sp from Excel is driving me crazy.
Thanks