Here is what's happening. SQL Mail sends out the query results as a text file. Now if we try to save this file with .csv extension, and open in excel, it does not work. But when we save it as .csv and select the ansi format, it works. How can we automate the process ?
quote:
Shouldn't be unicode. Is your server setup for Unicode? What code are you running to get the Unicode results?Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/