Hi ,

I joined this community today and this is my first message.

I have a query regarding import into excel.
I have a DTS through which i am getting data of a table in excel sheet. But excel is treating the numeric values as string/text.
I know that i can change them by copying and pasting the content using Paste special.
But i do not want to change them explicitly.
Is there any way by which i get right data.



Regards,
Sushant Pandey

Unfortunately, I don't think DTS will allow you to format data for the target application.

You can GET the data FROM Excel and format it that way, or you can use the following code on the range of cells:

Worksheets("Sheet1").Range("A17").NumberFormat = "Number"

You can also ust click the column heading and format the whole column at once.

HTH


mmcdonal

Actually this DTS is going to be used behind the code and the excel will be generated automatically. And i dont want the user to change the excel. i just want to give them complete and correct data and hence they can use that sheet as per their requirement.

Regards,
Sushant Pandey

I would pull from Excel rather than push from SQL.

mmcdonal