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 |
|
bubix
Starting Member
24 Posts |
 Posted - 2005-11-22 : 17:21:02
|
| Hello,I use the statement "Bulk insert" to insert data from a file to one table on SQL Server.I do like this:bulk insert MyBase.dbo.Clients from 'D:\DataMyBase\TableClients.txt' wiht (FieldSeparator = ',', Rowseparator='\n')Table Clients(num int, name char(50), comment varchar(max))But im my file "TableClients.txt", I have one row like this:7,Peter,'Hello,World"\nYou can see, I want to use "," in my column comment but I have this message error:Type mismatch...It's because I use "," in my comment and for statement "bulk insert", it's a field terminator and then I have a number of colums different from my table "Client".How can do If I want use "," in my field??? |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
|
|
Problem with Bulk insert