Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |