I couldn't get past a runtime error using the VBA script but found a more direct and easier way to get data from a SQL Server into Excel 2003. I...

I don't see a response to your question. For this error, I added a reference (Tools --> References) to Microsoft ActiveX Data Objects 2.5 Library since I'm using Excel 2003