I would like to insert a record from a CSV file into 2 tables, but it's line by line instead of conventional CSV separated. I am using c# and MSSQL.
My data is like this and its about 70 lines, they will be always in the same order :
AAA ( would go in table1)
How could I do that ?