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 used the wizard that opens from Data --> Import External Data --> Import Data and added a new data source pointing to our SQL Server (2005).