I need to write a console application using c# to import a comma separated text file into sql table.
If the sql table already has lien code, It should update the record else it should insert a new row.
I am attaching the text file. I have added column names for your reference. The first column is a fixed lenght of 52 characters and the remaining are comma separated.