Importing Excel into MySQL

Heres a brain buster for you guys. I need to get information from an Excell Spreadsheet into a MySQL database. I've gotten it to work to a point but it always falls short. I've saved the file as a Tab Delimited Txt file and then tried to import it into MySQL. All the information goes in correctly, its just not sperating into the correct feilds. If you don't knwo hwo to go from Excell to MySQL what about Access to MySQL? Either way works for me so long as I don't have to put it all in by hand. Thanks guys!

Save the file as a CSV file (comma seperated values) not as a tab delimited file. How are you importing the file, through the MySQL shell or through a third party tool like PHPMyAdmin.

You can also export directly from access to a CSV file so that might save you a step. Also make sure the CSV fields are in the same order as the MySQL table Fields.

Thank you Sooooooo Much. I was definatly not lookign foreward ot having to put 5000 records in by hand.