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/[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.
