Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smorty44
Yak Posting Veteran
93 Posts |
 Posted - 2007-12-11 : 10:32:04
|
| I am importing csv files into sql 2000 using odbcbcp and am getting the '' symbols when there are null values. Has anyone ever seen this? Or know how I can prevent this from happening? I am required to use odbcbcp to import this data. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2007-12-11 : 11:53:06
|
| Are you using quoted identifiers?Mike"oh, that monkey is going to pay" |
 |
|
|
smorty44
Yak Posting Veteran
93 Posts |
Posted - 2007-12-11 : 12:12:09
|
| yes, i have SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOhere is an example of my raw data:-37,0,"SVCS","","","4th Ave SE","allup","DA","372","",4296,0,"93006",0The 3rd and 4th columns come into my sql table with '' |
|
|
|
smorty44
Yak Posting Veteran
93 Posts |
Posted - 2007-12-11 : 12:13:02
|
| I'm sorry the parenthesis symbol is what is showing up but it's not showing when I post. |
|
|
|
smorty44
Yak Posting Veteran
93 Posts |
Posted - 2007-12-11 : 12:16:09
|
| the symbol that shows when you hold down the alt key + 0182 |
|
|
|
smorty44
Yak Posting Veteran
93 Posts |
Posted - 2007-12-11 : 13:19:14
|
| Has anyone used odbcbcp.exe to import their .csv data files? I need help with my usage flags and this nasty paragraph symbol I keep getting in my data. |
|
|
|
|
|
|
|
|
Importing null values getting symbols