Suggestions for Excel to mySQL import?

[punkstop]

Hey gang,

I have a simply structured, but large, Excel spreadsheet that contains important catalogue data for my future site here on powweb. Does anyone have any good suggestions on the best way to import this spreadsheet into being a new mySQL table? Is it even possible?

Any help would be greatly appreciated!

thanks very much,

John
webmaster to be - punkstop.com

[punkstop]

Hold the phone...I just stumbled across phpmyadmin's "Insert data from a textfile into table" feature.


Very very handy, I love it.



My apologies for the hasty mboard post above.

[user00265]

I don't think that'll work. PW doesn't allow file uploads to MySQL servers.

[mitchind]

Are you going to create the table first using phpMyAdmin - add the fields as they're laid out in your Excel file?