Loading data into a PostgreSQL table from Excel you need to use SQL*XL's insert multiple rows feature. To automate this process, just switch on the Excel macro recorder. The recorded code will look something like this:

Now, to do this from PHP you need to use the OLE features of PHP (I think PHP can do this but I am not 100% sure) to start Excel and open a .xls file in which you have saved the above macro code. The easiest is if you also record the logging on to the database into a macro. To start the process when you open the macro workbook code a call to your macro in the Workbook_Open event. If you code a second line in this event to close Excel when the insert is done you have completed the task. Again, I don't know how easy - or desirable - this would be from PHP. Why not use Excel and schedule the running of the macro workbook in the Windows scheduler?

Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap