Tried that. Csv, odf, etc. What I found is that I have no control over the PHP variables that PhpMyAdmin uses on my remote shared host.
So, it bombed all the time as the file was too big. That is why I downloaded xaamp so that I could try it on my desktop. Works like a charm on my desktop. But, while doing all of this, I ran across a program that will read in the spreadsheet and create a SQL Insert statement for me that works even better because there was garbage in the spreadsheet, and doing it via VFP, I could program out those errors. Funny how VFP still keeps on fixing things, isn't it? <grin> I'll send you a copy of the code if you want it. And the spreadsheet can be found here if you want to try it. http://www.foreignlaborcert.doleta.gov/performancedata.cfm#dis look for the one titled lca_fy2013.xlsx under lca programs -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, September 04, 2014 11:27 AM To: ProFox Email List Subject: Re: [NF] xampp On 2014-09-04 12:17, Virgil Bierschwale wrote: <snipped> >> Been having a hard time trying to upload a 442,000 record spreadsheet >> to mysql, so I wanted to figure out what was wrong by doing it on my >> box where I have more control over it. I would suggest you export the spreadsheet to a CSV file and use the LOAD INFILE (usually there's a GUI screen for it to make it easy). I upload tens of millions of rows this way and it works very well and quick. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
