Re: convert Excell to MySQL table

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Le Mardi 17 Juin 2003 17:19, Adam Voigt a écrit : > If it doesn't have to be automatic, I believe you can open > an ODBC connection to the MySQL database and use the export > functionality of Excel. I may be wrong since it's been a > while since I've done anything with Excel, but it's worth > a try. > > On Tue, 2003-06-17 at 11:09, Alex Shi wrote: > > Hello, > > > > Does any one out there happend to know a php solution to directly > > (without CSV) transfer an Excell spreadsheet into MySQL table? > > Thanks in advance! As far as I remember, you may have some trouble with the primary keys, when exporting excel tables to MySQL through MyODBC... They seem to be recorded as normal fields, not primary key. Well, i'm not sure ;-) - -- ,, (°> Nicolas Costes /|\ IUT de La Roche / Yon ( ^ ) Clé publique: http://www.keyserver.net/ ^ ^ http://www.gnu.org/philosophy/can-you-trust.fr.html -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+7zdyNc2aXy7LuOgRAt3sAJ9HqRuqUQMWWYbhiEtj9tNsEhXGXACfe7zG rdu7+/CFVLhn18e6+KWhzRc= =jg3+ -----END PGP SIGNATURE-----