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
|
|
