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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Bulk Insert Issue

Author  Topic 

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2014-04-21 : 21:03:50
Hi,

I am trying to import CSV files into my table

I have three columns in my table.

TableName : Keys

key nvarchar(50)
English nvarchar(4000)
Spanish nvarchar(4000)

My logic:

BULK INSERT Keys
FROM 'F:\Keys.csv'
with ( FIELDTERMINATOR =',', FIRSTROW = 2,CODEPAGE = 1252);

the reason i am using codepage=1252 is to insert Spanish text.

I am able to do the bulk insert. I could see some row values of English column has double quotes and some text of the row cut and moved with Spanish Text. Not sure why.

Any suggestion please how to insert exactly what i have in my CSV file.

Thanks in advance

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2014-04-22 : 11:25:31
I found the issue. it's not because of bulk insert. i have data issue with my csv file. So no issues now.
Go to Top of Page
   

- Advertisement -