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


From: "Adrian Schimpf" <[EMAIL PROTECTED]>
To: <>
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?


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 (
To unsubscribe, visit:

All-in-one security and maintenance for your PC.  Get a free 90-day trial!

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to