Data types when importing Excel data to SQLServer

  • Thread starter Thread starter matsbe
  • Start date Start date
M

matsbe

Hello,
I'm trying to import data from an Excel datasheet to Microsoft SQL
server 2003 using the import wizard, but I'm having trouble with one
data column. When a cell has a value of, for example,
E4/E20, the slash character seems to pose a problem. I have tried
importing as both varchar, nvarchar, and several other data types, but
I can't get it to work - the entries with "/" characters aren't
imported.

What data type should I use to be able to import such values?

Thanks in advance!

Regards,
Mats
 
Back
Top