mail attachment problem

I have an application that does an inventory comparason every night and
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
PaulProbably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
it all.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in the
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separator
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everything
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> > I have an application that does an inventory comparason every night and
> > emails the descrepancies to the business owners every morning. I am in the
> > process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> > found a problem with the email attachment. The mail that is sent is
> > generated using SQLMail, with @.attach_results set to true and the @.separator
> > = ','. When the mail arrives from the 2000 server, and the attachment is
> > opened, Excel gives an error message that says "This file is not in a
> > recognizable format." If I detach the file, open it in Notepad, copy and
> > paste the contents into a new file, change the extention to csv, everything
> > works. This has been working in 6.5 for 3 years.
> >
> > Any help will be appreciated.
> >
> > Paul
>
>