Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
How can i preserve data type during the export to ExcelWhen 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).
Post Follow-up to this message
Re: How can i preserve data type during the export to ExcelOn 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
Post Follow-up to this message Re: How can i preserve data type during the export to Excel> 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
Post Follow-up to this message Re: How can i preserve data type during the export to ExcelMaybe 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.
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
