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.

    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

      Write a Reply...