Excel - can A2k Row values become Column Headers ?

  • Thread starter Thread starter saustin
  • Start date Start date
S

saustin

Hi All,
Have a !!$% excel workbook that i need to populate
with different values from two A2K queries. Is it possible
to create excel column headers from A2k row values ? In
this case I have 60 of them. Have always just populated an
excel worksheet with a query and the field names have
become the excel column header names.
Once this is accomplished i then need to update
certain excel rows with values from that query rows.

Have never done anything but a complete worksheet
creation from a query so any ideas are greatly
appreciated.

Thanks, Steve.
 
Is it possible
to create excel column headers from A2k row values ?
Click to expand...

Look at Transpose method in Excel help. If you are using ADO, then you can
transpose the resultset from GetRows method. If you are using DAO, use
CopyFromRecordset to first transfer the records, and then use Transpose in
Excel by copying all the cells and then PasteSpecial with Transpose:=true.

-- Dev
 
Back
Top