Hello Guys,I'm facing a problem since last night, please help me! Actually I want to import csv file data in sql server database but I didn't. Could you explain it with code?Please reply as soon as possible. Thanks in advance!!
Hi Tanuj Kumar,To import data from csv file in SQL Server, you have to use BULK Query Command. Let's take look of Bulk Query Command query.Query: BULK INSERT tbl_Name FROM 'csvFileNamewith Path' WITH ( FIELDTERMINATOR = ',' ) I hope it might be resolve your problem.
Total Post:134
Points:940MSSQL Server MSSQL Server
Ratings:
2572 View(s)
Rate this:
I'm facing a problem since last night, please help me! Actually I want to import csv file data in sql server database but I didn't. Could you explain it with code?
Please reply as soon as possible. Thanks in advance!!