Exporting CSV Stream to a file that is ANSI not UNICODE

a CSV unicode file does not look good in Microsoft Excel (while maintaining
it's delimiters). I want to keep the file as a real CSV, but have it open in
Excel. If I save a unicode CSV as ANSI (notepad/wordpad) then it still looks
OK to other programs, and looks good in Excel.
I'm doing a
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()
type method to write the file... how do I get it ANSI?I should say that I have already tried "&rc:Encoding=UTF-8" but maybe it is a
report design issue too... all values come into the A cell|||Got it.
It was a Device Info setting not a render format:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp|||Just a note, in RS 2005 (out in November) there will be a sitewide setting
for the export to export in ASCII instead of Unicode.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
news:B132C76A-597D-4733-8166-7C6CAD87D06D@.microsoft.com...
> Got it.
> It was a Device Info setting not a render format:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
>

export to unicode textfile with tsql

Hello,
is it possible to write the he result of query to a unicode textfile instead
of an ansi textfile. i need this because i want to generate udl files on the
fly.
any help appriciated.
GerbenHi
You don't say how the file is created but...
osql has a -u parameter that creates a unicode file.
John
"gerben" wrote:

> Hello,
> is it possible to write the he result of query to a unicode textfile inste
ad
> of an ansi textfile. i need this because i want to generate udl files on t
he
> fly.
> any help appriciated.
> Gerben