I am trying to transfer data from an excel file to the database using DTS... I have a column for dates in my excel where the format of the date is like '02-Jan-2008' and in the database table the datatype for this column is nvarchar.... I have set the IMEX property to 1 in DTS connection properties...With this property set, if I am right the date should be inserting as '02-Jan-2008' into the database...Instead it is getting inserted as '08/01/02' ...

Please tell me why this is happening.. does this have anything to do with cultural settings...

And also provide me with a solution to avoid this....


Thanks and Regards,
Jhansi

__________________
Thanks and Regards,
Jhansi

Which database are you using?
None of the databsaes that I know stores the date in dd-mon-yyyy format.
It always stores date in the format mm/dd/yyyy or a similar one.
There are function availabe to display the date in the desired format.

If you can let me know where you need the date in a particular format from the database, I might be able to help you more on this.

- Vishu