Import Exel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
moiseszaragoza
Forum Commoner
Posts: 87
Joined: Sun Oct 03, 2004 4:04 pm
Location: Ft lauderdale
Contact:

Import Exel

Post 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
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Import Exel

Post 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.
User avatar
moiseszaragoza
Forum Commoner
Posts: 87
Joined: Sun Oct 03, 2004 4:04 pm
Location: Ft lauderdale
Contact:

Post by moiseszaragoza »

Thanks
Post Reply