Re: convert Excell to MySQL table
| From: | Adam Voigt | Date: | Tue, 17 Jun 2003 15:19:33 +0000 |
| Subject: | Re: convert Excell to MySQL table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-151850@lists.php.net to get a copy of this message | ||
If it doesn't have to be automatic, I believe you can open
an ODBC connection to the MySQL database and use the export
functionality of Excel. I may be wrong since it's been a
while since I've done anything with Excel, but it's worth
a try.
On Tue, 2003-06-17 at 11:09, Alex Shi wrote:
> Hello,
>
> Does any one out there happend to know a php solution to directly
> (without CSV) transfer an Excell spreadsheet into MySQL table?
> Thanks in advance!
>
> Alex
>
>
> --
> ==================================================
> Cell Phone Batteries at 30-50%+ off retail prices!
> http://www.pocellular.com
> ==================================================
> TrafficBuilder Network:
> http://www.bestadv.net/index.cfm?ref=7029
> ==================================================
--
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group