You can use ODBTP (http://odbtp.sourceforge.net) to connect to it using MS's ODBC driver for Excel.
-- bob On Fri, 6 Feb 2004, Griffiths, Daniel wrote: > I dont know any way to actually open and read the file with php, havent come across > any classes or methods that will do this. > > My solution when I had this problem was to do it in 2 parts, run a macro on the > excel file that will extract the data to a text file and then use php to read that > into the db. > > if there is a way to open excel files and read them with php i'd love to know about > it. > > > > -----Original Message----- > From: Bruno Pereira [mailto:[EMAIL PROTECTED] > Sent: 06 February 2004 03:36 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Acessing a excel worksheet from a php site > > > I'm making a site to a company and they have a excel worksheet where i have > to get the data to a site in php. > My question is simple, i think, how can i get it? > > > Cumprimentos > > Bruno Pereira > DSI > [EMAIL PROTECTED] > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
