Wow - what a pain! I figured that if the Wizard has an option like that - you would think that VFP would have a similar "switch" that you could use when importing programmatically!
Well - I quickly hacked the code together - based upon what I mentioned below - and it works. But - at least it was good to know that it wasn't something that I was doing wrong in particular... -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Quilhot Sent: Thursday, November 11, 2010 12:24 PM I know the import wizzard will allow you to designate if the first record is a header, but don't know the code / switch for it. Rick Q [email protected] On Thu, Nov 11, 2010 at 12:17 PM, Kurt Wendt <[email protected]> wrote: > I'm working on this system for a client - where we need to import CSV > data into VFP. This particular CSV file gets generated from UPS > Worldship. Upon importing the data - we noticed that the top record in > my system was not getting the Tracking#. Upon stepping thru the program > - I found that the 1st line of data from the CSV file was NOT being > Imported at All by VFP! > > Now - I know a standard CSV file has field/column labels as the 1st > record of a CSV file. However, upon opening up the CSV file from UPS in > Notepad - I saw that the CSV file did NOT contain those field headers! > And, so - I am assuming that VFP is considering the top line of data as > field headers - and therefore ignoring the record. > > Could I be doing something wrong? Or, is this just a Non-Standard type > of CSV file - and now I have to code things differently to handle it??? > > If I have to - I will code a work-around. My QA Tech buddy suggested > that I open the CSV file and insert the field headers. Although, what I > would really do is just generate this stuff to a secondary/temporary > type CSV file - as opposed to messing with the original one. > > But, I figured I would post a message here to see what others thought... > > Thanks, > -K- _______________________________________________ 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/289ea162f5642645b5cf64d624c66a1409df1...@us-ny-mail-002.waitex.net ** 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.
