Header row in Excel after a DTS export -
07-12-2006
, 09:16 AM
Problem: I need to provide an Excel spreadsheet to a partner. I export
the data from SQL Server 2000 to the Excel spreadsheet, using DTS,
without a problem, however, the header row is inserted as the first row
of the sheet. I have been manually removing the header row before
FTPing the document and now I really need to automate this process.
What I really would like to do is configure the DTS package to just
export the data to the spreadsheet and ignore the header. I am able to
export the data to a txt file that doesn't include the headers, but not
with a spreadsheet.
Thanks you in advance for your help.
-Topher |