and look athe link inside that link Importing CSV file into Database with Schema.ini - Creating Schema.ini file dynamically or at run-ti...
and the requirements in there
Points to remember before creating Schema.ini
1. The schema information file, must always named as 'schema.ini'.
2. The schema.ini file must be kept in the same directory where the CSV file exists.
3. The schema.ini file must be created before reading the CSV file.
4. The first line of the schema.ini, must the name of the CSV file, followed by the properties of the CSV file, and then the properties of the each column in the CSV file.
and it is a text file... so create in a text editor, and explore with different options until you get it right. You can't foul up the csv file in any event... and even if that happened you would have your backup