http://www.ustrem.org/en/articles/reading-xls-with-php-en/ <http://www.ustrem.org/en/articles/reading-xls-with-php-en/> http://sourceforge.net/projects/phpexcelreader/ <http://sourceforge.net/projects/phpexcelreader/> http://www.phpclasses.org/package/3797-PHP-Access-Excel-spreadsheets-as-data... <http://www.phpclasses.org/package/3797-PHP-Access-Excel-spreadsheets-as-databases-using-ODBC.html> http://www.phpclasses.org/package/1919-PHP-Stream-wrapper-to-read-and-write-... <http://www.phpclasses.org/package/1919-PHP-Stream-wrapper-to-read-and-write-MS-Excel-files.html>Depending on how the rows and columns are arranged in your spreadsheet: 1. Load the excel sheet in a new thread so that the request doesn't go dead 2. Use a loop to read columns and rows and based on that generate a huuuuge SQL statement 3. Run the SQL statement 4. Data's in your table On Fri, Jan 28, 2011 at 1:54 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance
On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- K. K.