Forum Moderators: coopster

Message Too Old, No Replies

Excel to CSV

         

sfast

4:54 pm on Jul 16, 2007 (gmt 0)

10+ Year Member



I am facing problem with excel to csv file conversion.

The excel file contains a field FIELD1 with values unique values like 00523243040617 for all the rows.

When I convert excel into csv file, it shows me values like 5.23E+11

When inserted through PHPMYadmin, it inserts only 7.

Why does csv change into decimal format?

Please help me.

sfast

5:21 pm on Jul 16, 2007 (gmt 0)

10+ Year Member



I dont know what was the problem. But I got it done.