On Thu, Nov 11, 2010 at 12:34 PM, John Weller <[email protected]> wrote:
> I have had problems like this. The command APPEND FROM <filename> TYPE CSV > will always drop the first line as it assumes it is the header. If your > data does not have a header line then use APPEND FROM <filename> TYPE > DELIMITED. It's mostly a terminology issue. In the minds of the FoxPro Developers, and Microsoft in general, a CSV file is a special case of a DELIMITED file with a first line of field names. (Check out an Excel export, for example.) Most of the rest of the world doesn't make that distinction. The Hacker's Guide covers this pretty well, iirc, and I think Tamar wrote up a follow-up article on it. DELIMITED WITH and SEPARATED BY give you the power to read a lot of different formats, at low-level speed, and without bugs in code you have to write and debug. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ 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.
