Coverting excel tables ot mysql tables

Any freeware available?

[s9901470]

Hi

Does anyone know any freeware that allows converting excel files into mysql tables? The ones I have seen so far have trial versions which only do about five rows.

Ed

[riverstyx]

Hi, Ed -

I'm no expert but I think you can save an Excel sheet as a .csv file and upload it to a table. I use phpMyAdmin and there is a text file upload option under SQL tab.

RS

[s9901470]

I'm using an older version of phpmyadmin which doesn't allow it unfortunately. My web hosting company say they aren't planning to upgrade it.

[DrDel]

looks like it is time to find a new web host

they won't allow you to upgrade phpmyadmin? jesus!

then the other way to do it if you HAVE to stay with your webhost is to save the Excel file as a .csv and then email it to your webhost and ask them to import it into mysql via the command line

if they provide you access maybe you can ssh it via the command line yourself

if they wont do it then you know it REALLY is time to find a new webhost!

[jatar_k]

you could write one yourself they aren't very complex

Take a look at this thread from our library
Basics of extracting data from CSV files [webmasterworld.com]

the steps laid out in message 2 would work. For step 4 just construct your insert query and then in step 5 issue that insert statement to mysql.

everything else is the same