Home Forums SQL Server 2005 T-SQL (SS2K5) Can DatabaseMail attach a formatted Excel file? RE: Can DatabaseMail attach a formatted Excel file?

  • February 29, 2008 at 3:00 pm

    #784066

    Jack Corbett (2/29/2008)

    Because you are naming the file with an "XLS" extension, Excel thinks it is a native file and is not looking for a delimiter.

    I would use "," for a delimiter and use a "CSV" extension on the file, then Excel will recognize it as a delimited file and because it is a csv, should open it in the correct manner.

    Thanks Jack. I did what you said and the file is delimited by commas but still all in the same column. I can open it in Excel but I have to go through the process of telling Excel to separate the comma delimited values.

    I'd really like this to be good to go when you open the attachment file.

    Thanks, Adam.