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

2006-12-01 Thread Adrian Schimpf
Hi All, Thank you for your comments. I was busy the last days with other projects so I didn't find any time to think about a solution. The VBA Module and the CSV are two ways I will give some further thoughts but I was hoping that somebody already had a solution and I don't need to write a VBA Sc

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

2006-11-23 Thread Bastien Koert
scripts that does the updates etc and then uses COM to create a new spreadsheet bastien 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 dir

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

2006-11-22 Thread Adrian Schimpf
>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) Re

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

2006-11-22 Thread Chris
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

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

2006-11-22 Thread Adrian Schimpf
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 i