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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-27 : 09:10:56
|
| kbdaemon writes "I have a CSV file which I'd like to bring into SQL Server 2005. I used the import/export wizard to bring the file into an existing table. No problem there, but when I do select statements all the data comes back with double quotes around each field in my data grid. Can I re-import and remove the quotes somehow? They're not present in the original CSV file." |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-04-03 : 11:53:06
|
| You certainly can.I am not sure how this is handled in sql 2005, but in sql2000, when you import them using the wizard, you have an option to choose text qualifier under select file format screen, the default is double quote, choose none will remove those double quotes. |
 |
|
|
|
|
|
quotes show up around all imported data in DB