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 |
|
calvinkwoo3000
Yak Posting Veteran
98 Posts |
 Posted - 2013-12-13 : 02:22:44
|
| i have a CSV file seperator with comma.my database have primary key. PK1, PK2, Data.my CSV sample data looked as below if i open with Text File:"Data 1", "data 2", "Data 3""Data 1", "data 2 ", "Data 3"when i run the import task, it prompt me duplicate primary key because it take the Data 2 with and without spacing as same data.I had set the Text Qualified = "Is there any setting to make the different of data 2?Thank you! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-13 : 07:11:51
|
| how are you doing the import? using export import wizard?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
import CSV with spacing data