hello!

I was trying to use DTS to copy data from excel to
SQL2000. In the spreadsheet, it seems like if it is blank
or empty values, it is defaulted to nvarchar (255). I
tried formatting the columns in the spreadsheet to
numbers, since my destination column in SQL2000 is a
numeric (18,5). But it is still not possible.

I encounter errors when my source datatype is
smalldatetime and destination datatype is datetime.
Another case is source datatype is nvarchar(255) and
destination datatype is numeric (18,5). Also, source
datatype is float and destination datatype is numeric
(18,5).

What can I do to convert the datatype of the spreadsheet
to the one that i want in DTS?
1) I tried using linked servers...but the conversion is
still the same.
2) I tried to convert the spreadsheet to text
file...doesn't really work.

Please advice.

Thanks!

Rgds,
Sam.

This probably will not help you, but Excel does not allow the user to
change the datatypes. They are what they are. You can format them to
display how you want them to look but you cannot change the underlying
datatype.

Rand
This posting is provided "as is" with no warranties and confers no rights.