I,m starting to learn sql 2008 R2 express and i have managed to make a bulk insert but when trying to eliminate quates as text qualifiers i,ve seen that i have to make a formatfile. Which application should i use to make this
formatfile and how should it look like to eliminate the quates that works as textqualifiers? I also wonder if it is possible to change the comma decimal separator to a period separator so i can use bulk insert for value fields. The file that i would like
to bulk insert looks like this.
2010-09-14;"Some Other Project";"4010";500,55552
View Complete Post