how to import a data from excel to xampp?

Question

how to linking/import a data from microsoft excel to xampp?
without any error?
can give me a step...
i have read in somewhere... but to many error...

Answer 1

xampp is package which primarily contains apache, php, mysql

i guess you want import data from excel to mysql. Here is the simple how to :



- save excel as Comma Separated Value file (.csv)

- create database

- create table in database which have number of columns is exactly same as excel number of column

- when create table, make sure you choose correct data type for each column which similar as excel data types. and remove column header at first line (if any)

- then import with this command (and run via phpmyadmin or mysql console) :



LOAD DATA INFILE 'path/to/file.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' SET id=null;



another way : find freeware via google to import excel to mysql

Answer 2

Here I am giving one link to explain your problem.

http://www.discussdesk.com/import-excel-file-data-in-mysql-database-using-PHP.htm

Answer 3

trx