How can i preserve data type during the export to Excel

When i export data to a Excel file numeric fields are exported as
General type in excel.
Does anybody know how can i preserve numeric type for this columns
(double, float or integer).On 30.10.2006 12:00, Sale wrote:
> When i export data to a Excel file numeric fields are exported as
> General type in excel.
> Does anybody know how can i preserve numeric type for this columns
> (double, float or integer).
>
How do you export them? Did you try to import them from Excel directly
via ODBC data source?
robert|||> How do you export them? Did you try to import them from Excel directly
> via ODBC data source?
> robert
I use DTS package for export to Exel|||Maybe better question is wich data type Excel accept as number when i
perform export from SQL server ( via DTS). I tried double (SQL offer
this as a default), and decimal, but result remain the same.