Wow, thanks... I'll have to look up the format part. I always use the visual tools. I just downloaded it and I'm going to read it now.
Again thanks, I update div-1 gm scores & statistics each week and then make predictions each week. I have a long way to go. It was hard to do in foxpro so I'm sure it will be really hard in xhtml, php, and mysql. Gary Jeurink -----Original Message----- From: MB Software Solutions, LLC [mailto:[email protected]] Sent: Sunday, October 14, 2012 11:23 PM To: ProFox Email List Subject: Re: from vfp-9 to mysql On 10/14/2012 10:01 AM, Gary Jeurink wrote: > I'm trying to populate mysql tables from my foxpro tables. The best I have > done is to export to text delimited files then use LOAD DATA command and it > does okay except I can't get the dates to go. I'm guessing they need to be > formatted some how. A row of text delimited looks like > > "DUKE",09/01/2012,"FLA INT",46,26,F,5796,"01" > > Then when I check the mysql table, everything is there but the dates read > 000-00-00. (2012 COLLEGE FOOTBALL GAMES) Gary, I've seen this. You need to format the dates in the 'YYYYMMDD' format. I had uploaded a tool to the ProFox downloads page a long time ago for taking your VFP data and uploading it into a MySQL table. http://leafe.com/dls/vfp http://leafe.com/download/VFP2MySQL_data_upload.prg -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5EC50EFC0D464E52AB73675575C15B3C@OwnerPC ** 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.
