| Author |
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).
| |
| Robert Klemme 2006-10-31, 12:15 am |
| 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.
|
|
|
|