Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export data using BCP command Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 3:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:08 AM
Points: 138, Visits: 934
Hi all,
I have a request from my client that they need to export data to an excel using BCP command and the excel file is with format:
Row 1: title of report = bold and place at column 3
Row 2: report date = dd/mm/yyyy and place at column 1
Row 3: header of columns = bold and background color is green
From the row 4, data will be display.
However, I am not sure about using XML format file which can handle that. Please any suggestions
Post #1406642
Posted Monday, January 14, 2013 12:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
Dung Dinh (1/14/2013)
Hi all,
I have a request from my client that they need to export data to an excel using BCP command and the excel file is with format:
Row 1: title of report = bold and place at column 3
Row 2: report date = dd/mm/yyyy and place at column 1
Row 3: header of columns = bold and background color is green
From the row 4, data will be display.
However, I am not sure about using XML format file which can handle that. Please any suggestions

You cannot export to Excel using bcp.exe. Use SSIS to export to Excel.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1406913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse