Transform a 2-dimensional Variant Type

Hi all,

i wanna try to import data from an access-recordset-object into excel.
Therefore I use a variant-datatype as temp, which becomes a 2-dimensional-array after exporting the recordset.

When I try to import the data into an excel-sheet with selected range, my variant-matrix is in an incorrect position and has to be tranformed first (rows->columns, columns->rows).

Just a short code example, where readout is the function which exports the recorset data into the variant datatype.

Dim temp As Variant

temp = readout(query, connADO, rstADO)

Dim ws As Worksheet
ws.Range("A1:E1000")= temp <-- temp has to be tranformed first

thanks for your help
PEter

What's your problem??Plz say fairly...