Data Import From Excel

This topic is locked

Data Import From Excel	1/4/2013 7:29:11 AM
PHPRunner General questions
I Ivan van Oosterhout author Hello, My best wishes to you all, i have an excel list with data in, This is the data: 760.260 790.148 I will be placed in a MySQL Varchar200 field but now i miss the DOT. How can i import the data with DOT ? Before Import Record? and then? Kinds Regards,


	Sergey Kornilov admin 1/4/2013
	I would suggest using FLOAT or DOUBLE field in MySQL for this purpose: http://dev.mysql.com/doc/refman/5.5/en/floating-point-types.html Also make sure correct regional settings are selected so dot is recognized as a decimal symbol.