You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management ... editor and type a Bulk Insert statement such as the following example ...

Today's use of BCP -- or SQL Bulk Insert, as it's referred to now -- is much simpler ... Use a DataAdapter fill a DataTable from a basic SQL statement, like this: SELECT ID, Desc, UseCode, Active, ...