SET DATE ANSI BEFORE YOU IMPORT JERRY -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Madigan Sent: Tuesday, February 21, 2012 6:54 PM To: ProFox Email List Subject: Re: How to import this date format from text file?
You might have to bring it into a text field then convert it later. ----- Original Message ----- From: "MB Software Solutions, LLC" <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Tuesday, February 21, 2012 7:36 PM Subject: How to import this date format from text file? I've got a text file I need to import. It's format is YYYY-MM-DD HH:MM:SS. When I do APPEND FROM Test.txt TYPE DELIMITED, it fails to bring in the date. (VFP9SP2) tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] _______________________________________________ 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/A6E15D4E5C784B4C84DFF4A3DA42A616@jerryfootePC ** 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.
