Excel CSV to MySql

[include_me]

Hi There,

I have a Excel CSV file with 5000+ records on and I would like to put this into a PHP MySQL database, I have CPANEL and PHP MY ADMIN but i cant seem to find where the section is to upload the file?

Can anyone enlighten me to how i go about doing this? I will probably split the csv up into smaller chunks so upload time is not timed out..

Any ideas?

Thanks
Chris

[maxpup979]

write a script to convert it into standard SQL? should just be some explodes and string replaces...but then again, I have little experience with either of the products you mentioned...So there might be a faster way.