DTS export to Excel

[TomR100]

I am exporting data from SQL to an Excel spreadsheet. One of columns of information is social security numbers. There are some of my numbers that have a zero (0) as the first number and when the data goes into the spreadsheet the zero is dropped. Is the any way to stop this from happening?

Is there any way to fill in column heading for the Excel spreadsheet through the DTS?

 

[sonname]

Your social security number is most likely a number field and excel sees it as just that and drops the leading zero. You can convert it to a string just prior to exporting to excel. If you are using DTS to export to an excel spreadsheet you can do some column manipulations like this.