Exporting to Excel

[airedale9]

The DTS package I am using to export data to Excel works fine, apart from inserting an apostrophe (') at the beginning of each field, which then makes it difficult ordering the data as required. How do I set up the package so this doesn't happen?

 

[swimtiger]

This may not be the solution that you are looking for, but you can use Edit, Replace in Excel to remove all of the marks.

 

[NilsBevaart]

When you export to Excel, are you using an existing Excel sheet or do you create a new one within the package?
Be sure to define the fields in Excel as numeric if so desired. Also make sure you select these fields using the correct datatype.

Good Luck,
Nils Bevaart

 

[Cheryl3D]

Hi airedale9:

How did you get the DTS package you are using to export data to Excel works fine, apart from inserting an apostrophe (') at the beginning of each field?

I think that I might need to do this, like when exporting Recordset results from SQL Server.

Did you use a stored procedure in your DTS package? What did the syntax look like when you inserted an apostrophe (') at the beginning of each field?

Your help would be greatly appreciated.
Thanks,
Cheryl3D