On Aug 8, 2007, at 2:00 PM, Daniel Brown wrote:
On 8/8/07, Jason Pruim <japruim@xxxxxxxxxx> 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@xxxxxxxxxx
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@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
