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 |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2014-02-12 : 17:12:17
|
| Im trying to import one column from a file (test.csv) and it fails. The test file i was using has one row and one column.here is the actual data. i tried to load to table which has one column . some special char is there in the data. create table test (desc1 varchar(1000))"Auto Exteriors specializes in auto painting,auto body repairs,collision repairs,customs,and restoration services. Personal and professional service for all your auto paint and body shop needs. Serving warrington,SC since 2005." |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-13 : 12:10:35
|
| what have you set as column and row delimiters? Also have you set text qualifier as "?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
flat file import