homepage Welcome to WebmasterWorld Guest from 54.166.111.111
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Coverting excel tables ot mysql tables
Any freeware available?
s9901470




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

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




msg:1291729
 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.

RS

s9901470




msg:1291730
 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.

DrDel




msg:1291731
 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!

jatar_k




msg:1291732
 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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved