Insert CSV file directly to database table

For inserting the data from csv file to table: Do the following steps,

1. create table schema( column name) in database with number of fields equal to csv file.
2. use the sql command
3. check the data in table.

step 2: sql command example:

bulk insert NewTableName from ‘c:\test.txt’ with(FIELDTERMINATOR=’,',ROWTERMINATOR=’\n’)