[SOLVED] OpenOffice spreadsheet automaticly enterd into a MySQL database. (ODBS)

[jimdidr]

I just installed ODBS and was hoping that i could put a spreadsheet from OpenOffice calc into a database.. (first row = firest entry, First collum = first part of every entry.)

 

There are sites out there that tell you how easy you can admin your DataBase using ODBS and OpenOffice Base and Calc but they do not seem to have the tutorial for massivly importing fra a Spreadsheet to a database...

 

I have a 4577 entries, that I need to input with 5 diffrent fields for etch... as "you" understand I don't want to do this manualy...

 

Any help out there?

 

Or is there another simple way?

[cooldude832]

You can upload a csv file phpmyadmin has applications for tihs

[jimdidr]

Thank you