Excel - can A2k Row values become Column Headers ?

[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.

 

[Dev Ashish]

Is it possible
to create excel column headers from A2k row values ?

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