Msg#: 4073736 posted 7:31 pm on Feb 3, 2010 (gmt 0)
I have a table with around 15 rows, one of them is Phone number field. SO when I export the database using Phpmyadmin and open that csv file in excel, the phone number format is lost, excel thinks that it is scientific number and does exponential functions. (eg. phone number 260000000, it changes this to 2.6E7), SO after all the hard work im thinking only to import few columns except the phone number. so is there any way that I can import only 2-3 columns which changes as per my needs into the database.