Re: Converting Excel Spreadsheet to MySQL table ...
| From: | David Eisenhart | Date: | Fri, 10 Jan 2003 17:39:00 +0000 |
| Subject: | Re: Converting Excel Spreadsheet to MySQL table ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131155@lists.php.net to get a copy of this message | ||
as a 'one off' exercise I recently did something similar except the data was
from Access, but would work the same from an excel file:- saved as
a CSV file and then used phpMyAdmin to import the CSV file data into a MySQL
table (of course, didn't have to use phpMyAdmin for this but it did make the
import process very quick and straight forward)
D
"Adam Ferguson" <adam@adamferguson.com> wrote in message
news:002001c2b86e$34514590$6601a8c0@FERG...
Hello ...
I was wondering if anyone had a good resource or code sample for opening (
or accessing ) an excel spreadsheet using php. I need to be able to convert
a spreadsheet of products and info to a table of products in a mysql
database. Also ... I need to be able to perform this on a Linux machine.
Any help would be great.
Thanks guys!
Adam Ferguson