Importing Excel into Mysql

[feliperal]

I'm kind of new to PHP. I need a way to import data easily from MS Excel to Mysql. Is it possible? If so, how? Also, are there any free tools? I tried importing using coma deniliated and tabs. Any help would be appreciated.

[jburfield]

It's really quite easy...

in MySQL:

load data infile '/path/to/file.txt' into table TABLENAME

file.txt should be a tabbed text file. That's really the easiest way.

If your table has more fields than the txt file, you can also do this:

load data infile '/path/to/file.txt' into table TABLENAME (field1, field2,field4,field7)

Check out the MySQL site [ http://www.mysql.com ] you will find a lot of helpful information.

-- Jason