Data types when importing Excel data to SQLServer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Access Subscript out of range when importing into access 2010 from excel 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Data 1
Importing data. Problem with datatype in column 2
Importing web data to Excel 2003 1
Importing Text Files Into Access 1
Excel 2003 - Importing External Data - formatting problem? 2

Top