I think Jeff's answer is the easiest way to do it, you could use Excel automation but that sounds like more of a pain than doing low-level files.
--- On Mon, 10/11/10, Jeff Johnson <[email protected]> wrote: > From: Jeff Johnson <[email protected]> > Subject: Re: Vfp9 to csv > To: [email protected] > Date: Monday, October 11, 2010, 7:18 PM > I do this all the time. I copy > to table to file type CSV. Then I open > up the file using VFP low level file access to add the > header to the > top. FOPEN() etc. > > I use the same technique if I need to change the header or > delete it if > it is there. > > Jeff > > --------------- > > Jeff Johnson > [email protected] > (623) 582-0323 > > www.san-dc.com > > > On 10/11/2010 04:12 PM, Sytze de Boer wrote: > > One of my clients needs to send information to their > bank in CSV format > > > > The system my client uses is made up of free standing > tables > > The bank requires 3 csv files and insist on headers in > exact format > > I'm having a problem where the request for headers > includes the following > > INVOICE NUMBER (note the space and length) > > CLIENT NAME (note the space and length) > > > > i.e. my routine to COPY TO BANK.CSV TYPE CSV does not > like this > > I would appreciate help for a work around > > > > > > > > _______________________________________________ > 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. > _______________________________________________ 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.
