Re: Not quite OT but maybe close... Help with MySQL

From:	Jason Pruim	Date:	Wed, 08 Aug 2007 18:02:01 +0000
Subject:	Re: Not quite OT but maybe close... Help with MySQL
References:	1 2	Groups:	php.general
Request:	Send a blank email to php-general+get-260444@lists.php.net to get a copy of this message

On Aug 8, 2007, at 2:00 PM, Daniel Brown wrote:

On 8/8/07, Jason Pruim <japruim@raoset.com> wrote:
Hey everyone, I tried asking this question on the MySQL list but haven't gotten very many helpful responses... Does anyone know how to successfully import a excel file into MySQL (To make it on topic) Using PHP? I have tried using LOAD FILE in mysql and it just imports the first row of my excel file with no errors... Any ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com
    It is a MySQL question, you're right.... but are you trying to
load a CSV that you read in Excel, or is it in Excel format?

Currently, the file is an Excel file, but I can export to csv, tab, txt, or what ever else excel can go to... So quite a qide array of options...

--Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 Hey, PHP-General list.... 50% off for life on web hosting plans $10/mo. or more at http://www.pilotpig.net/. Use the coupon code phpgeneralaug07 Register domains for about $0.01 more than what it costs me at http://domains.pilotpig.net/.

-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com