Import is ignoring field values

[cjkenworthy]

I'm using the wizard to import an Excel spreadsheet: some of the rows contain values such as e.g.

74.70/1
74.70/2
74.70/3
74.70/4

I have specified these as 'General' cells in Excel. When I do an import (creating a new table at the same time) SQL seems to NULL out these values and not recognising them. I have tried specifying the column type in 'Column mappings' as 'varchar', 'nvarchar' to take the values as text, but it still seems to NULL them out.

Is there anyway to force SQL to take the values in the Cells as it is, without transforming it or reformatting it?

The data has to appear exactly as it is above.

Thanks.

 

[cjkenworthy]

The trick is to use CSV files, not Excel - as it plays around with the data format.

Fixed it.