You could also put the query in the Excel spreadsheet using the external data source tool. Once that is done you could just refresh the spreadsheet on the fly.

Not really knowing the issue one thing might be your connection properties in T-SQL are different then the database settings.

Can you just set ANSI_Warnings off at the top of the SP?

jcdyntek (1/13/2010)

---

You may be able to alias the table name in the update statement in Oracle but

The table name in the UPDATE can't be aliased in T-SQL or in Standard...

Just...

also make sure you spelled dba correctly on your resume 😀

I think it has to do with using Unicode formatting.

Run through this just to get the flavor:

http://www.w3schools.com/sql/default.asp