Direct Import Excel Data to MySQL (without CSV)

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

Re: Direct Import Excel Data to MySQL (without CSV)

Adrian Schimpf wrote:
> 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.

That's probably the only way to do it.

What do you mean you can't write the data back - do you get an error?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

AW: Direct Import Excel Data to MySQL (without CSV)

>What do you mean you can't write the data back - do you get an error?

I try to edit the data on the Excel surface and then when I made some
changes I would like to safe them back in the MySQL Database.

Is it possible to write the data back with the common Excel
functionality (including ODBC)

Regards, Adrian

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: 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"
>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?
>
>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/dire ct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmai l

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php