RE: [PHP-DB] Direct Import Excel Data to MySQL (without CSV)

Adiran There are several solutions that i can see in doing this without csv 1. create a vba module in the excel sheet to handle the connections and insert/update the data in either direction. This does suppose that the web server you are using can be accessed directly from the client machine you are not and not hidden behind a firewall. 2. save the file in a tab or fixed length format (what do you have against csv any way?) and upload the whole file to the server. Write a php script that uses mysqload to load the file into a second similar table to the main one. Write another php scripts that does the updates etc and then uses COM to create a new spreadsheet bastien

From: "Adrian Schimpf" <schimpf@ergosoft.ch> To: <php-db@lists.php.net> Subject: [PHP-DB] Direct Import Excel Data to MySQL (without CSV) Date: Wed, 22 Nov 2006 15:09:19 +0100 Hi together Is there a way to direct import MySQL data into an Excel Sheet, edit it and click a button to upload/sync it? I'm already using an ODBC driver to import the Data but then I'm not able to write the data back. Is someone using a reliable solution? Regards Adrian Introduction: This is my first post to this list, even though I'm a frequently reader of the list. Here is a short introduction: I live and work in Switzerland as a webmaster. Currently doing a lot of internal (intranet) projects such as an address db, etc. Mostly using PHP and MySQL (JS/CSS/HTML) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ All-in-one security and maintenance for your PC.  Get a free 90-day trial! http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail