RE: CSV file with a header

["Terry Anderson" <TAnderson@xxxxxxxxx>]

Pat,
If commas are being use to separate the values, the field length
shouldn't matter.  Are you saying that this is not a CSV (Comma
Separated Values) file?
 


Terry Anderson 
Programming Manager 
Grede LLC. 
Switchboard 1.251.867.5481 ext 212 
Direct Line 1.251.809.2312 
Fax 251.867.0525 
Cell  1.251.363.4975 



message: 9
date: Tue, 18 May 2010 11:45:58 -0400
from: Pat Barber <mboceanside@xxxxxxx>
subject: CSV file with a header

I have been asked to create a CSV file to send to an outside company.

They sent me a standard file layout and I created the file just fine
using
a file transfer request using Access.

Got a note back and now they want a "header" record inserted as
the first record of the file. This header record is nothing but column
heading with descriptions.

Since the file has fixed field lengths, I can't just put a dummy record
there to create this stupid header.

I need to be able to store the CSV header record somewhere and copy it
as the first record on each file transfer.

Any ideas.