I am trying to import data (csv file) to sql server 2008 using import data wizard. I have three questions 1. In the "general" tab there is an option "text qualifier" under "format". Do you know what is it? 2. In the "Advanced" tab there is an option "text qualified" with the value "true". What is that? 3. Finally when the csv file has empty value and when i choose this column to be float the number "0" appears instead of NULL. Do you know how to change it? Thank you very much George
To answer your questions, 1. is the field delimiter in the case of a csv file that's likely to be a comma (,) 2. The text qualified means that you have set how the columns are going to be split 3. Float is a numeric field and will therefore always bring back a zero instead of null, would suggest the change of field to varchar if you require nulls Hope this helps.