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
Need to stop automatic column re-sizing when importing XML data 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing web data to Excel 2003 1
Importing Data 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Excel 2003 - Importing External Data - formatting problem? 2
Removing Data Tables formed from importing data from Access 0

Top