Re: CSV file with a header

When people ask me todo that i just make a UNION and in the second SQL
statement I have the column headings.

It means that any field in the result set must be character, but imported
in Excel it does not matter.

To seqquence the result I finish with a hex value and use that to order the
result set.

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 18-5-2010 at 11:45 Pat Barber wrote:

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.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Interne Virusdatabase is verouderd.
Gecontroleerd door AVG - www.avg.com
Versie: 9.0.801 / Virusdatabase: 271.1.1/2820 - datum van uitgifte:
04/19/10 08:31:00