Page 1 of 1

Import Exel

Posted: Wed Sep 13, 2006 10:33 pm
by moiseszaragoza
I have a exel file that i have to import to a Database
I was wandering what is the best way to import the file

There are 8414 records

Re: Import Exel

Posted: Thu Sep 14, 2006 3:58 am
by onion2k
moiseszaragoza wrote:I have a exel file that i have to import to a Database
I was wandering what is the best way to import the file

There are 8414 records
Dump it as a CSV file, the use LOAD DATA INFILE in mysql's CLI client.

Posted: Thu Sep 14, 2006 1:23 pm
by moiseszaragoza
Thanks