Importing CSV File into the SQL Server

I want to import the CSV file into the database using the file I uploaded! The two columns of the data I wanted will be starting from Cell A12 to B12 and down to A27 and B27. The top portion of the CSV file will be ignore. I was wondering if anyone done something similar to this?CF20.csvI want to import the CSV file into the database using the file I uploaded! The two columns of the data I wanted will be starting from Cell A12 to B12 and down to A27 and B27. The top portion of the CSV file will be ignore. I was wondering if anyone done something similar to this?

You can open the file with Excel and remove the information that is not required. I recommend you first delete the rows after 27, and then rows before 12. Also, delete columns after column B. Your csv file will then look like this:Then save the file as csv and just use bcp utility to import the file, like this:

Chaau is correct about cleaning up the CSV before importing.
After that, you can alternatively also use the import wizard in the SQL management studio to import the file. Right click on the database name, then select Tasks - Import data. Indicate your data source (flat file for CSV or, if you want to make it a bit simpler, save the csv file as an Excel workbook and select Microsoft Excel as data source). Check the other settings and verify if anything needs changing. On the next screen, indicate your data destination.
When you get to "Select source tables and views" you can have the wizard create a table for you (default), or select an existing table. Always check the mapping if you import into an existing table. After that click next until you can execute the package, and the data should be imported.

Where do these csv files originate from? Are they exports from another system? If so, perhaps you can change the way the csv is generated.
Alternatively you might be able to do something with macros/VBA in Excel, where a bit of code would first insert the csv content in a structured Excel template before you import it to SQL. Not my area of expertise but others on this forum know.