Welcome to WebmasterWorld Guest from 54.167.58.159

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Coverting excel tables ot mysql tables

Any freeware available?

     

s9901470

11:33 am on Nov 22, 2005 (gmt 0)

10+ Year Member



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

12:20 pm on Nov 22, 2005 (gmt 0)

10+ Year Member



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

12:29 pm on Nov 22, 2005 (gmt 0)

10+ Year Member



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

1:33 pm on Nov 22, 2005 (gmt 0)

5+ Year Member



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

4:00 pm on Nov 22, 2005 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month