Thanks..

now I'm going to try...

Unfortunately I can't modify the Excel, I must only import...

Do you think that the problem is the comma or point as decimal?

Have you...

Thanks Osama,

your solution is useful, but do you know if there's a way to made transformation while charging data without a Temp table?

I...

Osama Kandil (10/22/2007)

May I suggest that you separate the tasks into 2 phases:

1. Use SSIS to import the Excel data into a table as it is exactly.

2. Use a...