Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2005 and DBMail used to gen a CSV file

Status
Not open for further replies.
JayKusch

JayKusch

MIS
Oct 30, 2001
3,199
US
OK ... I have DBMail generating a CSV file from a query.

ALL WORKS GREAT! I get the email and attachment.

Issue is when I try to open the CSV, Excel comes back saying it does not recognize the file format.

If I continue to open it, all of the column headers are in one cell as well as all the fields generated by the query are in the same row(s). I even see the comma "," seperater inbetween each column so I know the delimiter is being placed correctly.

I am also able to save the attachment as a TXT file and then I am able to import it as a comma delimited file and it brings it in just fine.

SO ... how do I correct the issue of the CSV not being in a format that Excel can open by default?

Thanks ALL!


Thanks

J. Kusch
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
558
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
354
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
599
pjw001
pjw001
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
691
gmmastros
gmmastros
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
513
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top