|
Home > Archive > MS SQL Server DTS > September 2005 > DTS Export Numeric Data to Excel as Numeric Data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS Export Numeric Data to Excel as Numeric Data
|
|
| bnhcomputing 2005-09-26, 11:23 am |
| I am trying to export data to an Excel named range via DTS. I have the data
transfering but all data is transfering to my empty named range as text. I
have formatted the area in excel as numeric before hand, but it still
transfers as text.
I have seen several references to this problem on the net, but no actual
solution.
My question, how do I transfer SQL Numeric data as Numeric data to excel and
endup with numeric data in Excel, using DTS?
--
bnhcomputing
| |
| bnhcomputing 2005-09-26, 1:24 pm |
| From my research, it appears that DTS data is ALWAYS exported to Excel as
character (text) data. It has been suggested that it may be possible to
overcome this with Excel automation (ie. once the data is in as text, take
control of excel, and reformat the data).
Are there any simple examples out there on how to do this?
--
bnhcomputing
"bnhcomputing" wrote:
> I am trying to export data to an Excel named range via DTS. I have the data
> transfering but all data is transfering to my empty named range as text. I
> have formatted the area in excel as numeric before hand, but it still
> transfers as text.
>
> I have seen several references to this problem on the net, but no actual
> solution.
>
> My question, how do I transfer SQL Numeric data as Numeric data to excel and
> endup with numeric data in Excel, using DTS?
> --
> bnhcomputing
|
|
|
|
|