Exporting to Excel format using bcp

• sevtech

  Valued Member

  Points: 67

  More actions

  April 23, 2003 at 9:58 am

  #80003

  Does anyone know if this is possible? I want to automate various weekly reports using stored procedures, where i will use bcp to output a query to a file and then email it. However, I really want to send the file in Excel format rather than .csv, as it will be better for the customers.

  Anyone got any ideas? Or if not, ideas on another way to do this?

  Cheers.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 23, 2003 at 10:16 am

  #455066

  You could create a dts package to import to an excel file, and then run it with a stored procedure and the send it by email.

  You can create an excel file with bcp.