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@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
