Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data types when importing Excel data to SQLServer
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data types when importing Excel data to SQLServer
Forgot to mention: the data type for the cells in Excel is "General".
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Microsoft query data into excel changes linked rows | Links and Linking in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Importing data to Excel using MS Query | Excel Discussion (Misc queries) | |||
importing data from Excel worksheet to another worksheet | Excel Worksheet Functions | |||
Translaton Error when importing Excel data into Outlook? | Excel Discussion (Misc queries) |