need to import to access the header row with each subsequent data

[Guest]

How do I import from Excel each row + the header row. In other words, I
want each row of the Excel sheet to also have the header row. The header
row is the only way i can identify the data. I can clean it up later with
SQL..

example

Header A, Header B, Header C
my field 1 myfield 2 myfield3
my field 4 myfield 5 myfield 6


So I want the import to be:

Header A, Header B, Header C, myfield 1, myfield 2, myfield3
Header A, Header B, Header C, myfield 4, myfield 5, myfield 6

tia,

 

[Douglas J. Steele]

There's no method to do that built into Access.

I suspect your only choice would be to use Access automation to retrieve the
data cell by cell. There's a very brief sample of how to do this at
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"

 

[Guest]

Douglas:
Thanks, I really appreicate the answer.

There's no method to do that built into Access.

I suspect your only choice would be to use Access automation to retrieve the
data cell by cell. There's a very brief sample of how to do this at
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"