| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Coverting excel tables ot mysql tables|
Any freeware available?
| 11:33 am on Nov 22, 2005 (gmt 0)|
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.
| 12:20 pm on Nov 22, 2005 (gmt 0)|
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.
| 12:29 pm on Nov 22, 2005 (gmt 0)|
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.
| 1:33 pm on Nov 22, 2005 (gmt 0)|
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!
| 4:00 pm on Nov 22, 2005 (gmt 0)|
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
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved