[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

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

[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