I am trying to import data from an Excel 2000 file into a SQL Server 2000 table. I am doing this through DTS.

However, when I transfer it in, the integer numbers are imported in as <<NULL>>. I have tried cast/convert but they have been rejected.

Convert - Undefined function 'convert' in expression
Cast - Unexpected error occured.

Can anyone be of help ?