I have following details in my file (it is not a csv file and also it has no special characters)
like wise i will be having plenty of rows in my file one below the other...
i have 3 columns CODE 1 , CODE 2 AND CODE 3 in my database.
Now what i need to do is insert first 9 (i.e. from 1 to 9 ) in column 1 , then from 1 to 5 in column 2 and from 4 to 2 in column 3.
Likewise i will loop through all the rows and accordingly insert data into the database.
MY QUESTION IS HOW TO SPLIT THIS FILE????? THIS IS NOT A CSV FILE THEN HOW TO DO IT??? PLEASE HELP ME OUT...
I HAVE WRITTEN CODE TO INSERT THE FILE DATA INTO THE SQL SERVER....ONLY THE PROBLEM IS HOW TO SPLIT THE FILE....