Welcome to WebmasterWorld Guest from 54.204.100.232

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

PHP import only few columns from csv

   
7:31 pm on Feb 3, 2010 (gmt 0)

5+ Year Member



Hello guys,

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.
7:46 am on Feb 8, 2010 (gmt 0)

5+ Year Member



is there any way to format the phone number, maybe throw a dash or two in there before importing, I truly despise that excel does this!