January 14, 2013 at 3:49 am
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 🙂
January 14, 2013 at 12:44 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply