Skip to Content
0
Former Member
Jul 21, 2010 at 04:56 PM

Reading each row of a .csv file in 12.1

66 Views

I have a .csv file with the first row as header information and multiple data rows. I aim to insert the data rows into SQL database. The functionality works fine with MII 11.5, where I loaded the content using a text loader and used a flat file parser to retrieve each row. But 12.1 the flat file parser gives me a single row with all the header and value data separated by commas. How can I read each row of the *.csv to make my database insert possible? Please help!