Sending in Column format

[ChrisCote]

Hopefully, this will be the last questions I have. First of all, I'm trying to send data to Excel in column format where all the labels go down the first column instead of across the first row. What I'd like to know is if there's a way to do this in Access. Also, if I am using an older version of Excel, say 5.0, how would I do this? Since I can't get the Excel object to work. I used to have it using a Database object, but I took it out and can't remember how I did it.

[bashfirst]

The key here is getting your data transformed from rows and columns to columns and rows. Using just Access you could create a recordset of your data and then create a temp table in the transformed format. Then just read the data (field names and all) into the table. Once that is done you can use the Access export to Excel to easily get the data over.

If you can get an Excel object working, you can do things similarly by creating a variant array of your data (transformed) and then paste the array in to a worksheet. The nice thing about the second option is the greater control you have over the spreadsheet as far as defining formats and such.

Hope this helps.

Bash