zeroes ommitted in the ID column
I have csv file that if I open it using EXCEL file, it ommitted the zeroes at the begginning of the text whereas if I am going to view using notepad, the ID is correct. For example, the value of the ID is 000102233, if I am going to view it using Excel it displays as 112233, which is also the value that my program gets if I extract it from the csv file and store it to database. How am I going to deal with it?