Transpose Data on Export to Excel

[MarkNie]

Hi All

I have had a look at the threads in the forum and could not find anything helpful to me.

Is there an easy way or a specific code I could use to do a transpose when I export a table to Excel.

Any help in this would be greatly appreciated.

Thanks
Regards
Mark

 

[lespaul]

use a query to get the data in the format you want and then export the query, not the table.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[PHV]

Why not simply use the Transpose worksheet function in Excel ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MarkNie]

Hi PHV

I would love to do that but, they want it all automated from top to bottom.

Thanks
Regards
Mark

 

[bubba100]

This might be an example of what PHV was talking about. Hear Access copies a range, selects a place to drop the copy and transposes when it pastes.
With xFile
.Windows("ExcelStuff.xls").Activate
.Range("A2:AU2").Copy
.Range("B4").Select
.Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
True, Transpose:=True
.Application.CutCopyMode = False

 

[MarkNie]

Hi Bubba100

Thanks for that.

I just need to know where to put this code, will it be in an expression in a macro or will this be code in VBA.

Thanks
Regards
Mark