Import data from "CSV" to SQL Server
Hi Friends,I need to import data from CSV file to SQL table.
This has to be done by either query/ SP or Wizard.
I have surfed, but am getting results like the below:
########
BULK INSERT dbo.TableForBulkData
FROM 'C:\BulkDataFile.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
#######
but in my csv am not using ", - comma", imy csv looking like a table and its opening in Excel. Now in this case how can i import my csv to table?
CSV having the same field as table contains.
Thanks in advance!
Best Regards,
Murugesan P