Adding headers

  • Thread starter Thread starter Tony in Michigan
  • Start date Start date
T

Tony in Michigan

Hello,
I need to add a header to a table to be exported in CSV format, which will
be imported and processed by another application.

Header is three rows
1Row x 3 fields file info. 2 fields are static, one is a three digit number
that changes for each file exported.
2Row x 46 field (1 or 2 row field labels all static)

above to be added to 46 field [my_table] saved and exported as csv file.

Currently, I insert the header into the exported data using excel. Can
anyone offer advise on how to do this within access?
 
It would be much simpler to create a form from the table, add in all the
headers you want, and then export to Excel.
 
I think I'm following what you are saying, but I'm having some trouble with
the mechanics within access.

Since this feeds another application, I need it to retain it's formatting,
as it appears in the table, so do I use Columnar or datasheet type form?

I tried datasheet, But I don't see how to add three lines in the header and
force the location of the data elements.



golfinray said:
It would be much simpler to create a form from the table, add in all the
headers you want, and then export to Excel.
--
Milton Purdy
ACCESS
State of Arkansas


Tony in Michigan said:
Hello,
I need to add a header to a table to be exported in CSV format, which will
be imported and processed by another application.

Header is three rows
1Row x 3 fields file info. 2 fields are static, one is a three digit number
that changes for each file exported.
2Row x 46 field (1 or 2 row field labels all static)

above to be added to 46 field [my_table] saved and exported as csv file.

Currently, I insert the header into the exported data using excel. Can
anyone offer advise on how to do this within access?
Click to expand...
Click to expand...
 
Back
Top