Hi,

I am working on DTS. I am transforming data from Excel to SQL Server
through DTS. The problem I am facing right now is, in excel I have some
value as 0.10665 but that cell is formatted as to take up to 3 decimals
so its coming as 0.107 but while transformation I want 0.10665.
Simple solution to this problem is to change the excel cell format. But
I cannot change excel.
So can we write any activeX script by which we can change the format of
excel??? If yes where can I get this code.

Thanks in advance,
Kedar

Hello risbudkedar (AT) gmail (DOT) com,

You could write code to change Excel but you just said you can't do that.

As for the data that comes out of Excel.


How do you manage to have in the cell the value 0.10665 if the cell is formatted
to 3 decimal places. In my XL it gets pushed to 0.107



Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hi Allan,

See at front, in the cell I am getting value as 0.107 but when u clicks
on that cell, in the formula bar u can see the actual value which is
0.10665. But I think DTS picks up the formatted value and not the
actual value. Can we some how pick up the actual value and not the
formatted value??? Please suggest.....

Thanks any ways for reply.
Kedar

On Nov 30, 3:05 am, Allan Mitchell <a... (AT) no-spam (DOT) sqldts.com> wrote:

Hello risbudkedar (AT) gmail (DOT) com,

I am not sure you can no. I think DTS will honour your formatting rules.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com