[PHP] Interfacing with Excel

2001-06-28 Thread Sharat Hegde
Hello, I have a web site on a Unix environment running PHP 3.0 and MySQL. I need to convert data in an Excel format to a MySQL database format periodically based on the input feed received in Excel format. the conversion to MySQL is not a problem at all. What I need help is to read data from an

Re: [PHP] Interfacing with Excel

2001-06-29 Thread Markus Fischer
You can use PHP4 under win32 (CGI Binary) and use the DCOM Interface to access excel. Search with google and some appropriate keywords. - Markus On Thu, Jun 28, 2001 at 11:00:19AM +0530, Sharat Hegde wrote : > Hello, > > I have a web site on a Unix environment running PHP 3.0 and MySQL. > > I

Re: [PHP] Interfacing with Excel

2001-06-29 Thread Miles Thompson
Are you getting an Excel2000 file and don't have Excel to open it? Just have it sent to you as CSV (Comma Separated Values) rather than XLS; that would be easy to parse. If you have direct access to the MySQL box, copy the file there and do the import directly. Check the MySQL docs. A more el