A tool such as "SQLyog MySQL GUI - Community Edition 6.52" from http://www.webyog.com/en/downloads.php will allow you to connect to your Excel spreadsheet using ODBC and allow you to import this way if you want. Such tools generally allow you to set up jobs which mean you can quickly and easily re-run the same process against different sheets.
Charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 18:01 To: [email protected] Subject: Re: [php_mysql] excel to mysql I've been trying to figure this out myself (but i'm still a novice these days) and was hoping there was some sort of code to write to import from excel as what i have planned will have excel files quite often.. [Non-text portions of this message have been removed]
