By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

Converting table to excel spreadsheet

P: 14
Hi all,


This is an example of how my table look like

A B C D E <<column headers
1 * * * *
2 * * * *
3 * * * *
4 * * * *

I know I can export the table directly into excel using:
Application.DoCmd.TransferSpreadsheet acExport etc etc

What I would like to do is to format it to appear in the excel spreadsheet as

A 1 2 3 4
B * * * *
C * * * *
D * * * *
E * * * *


Is there any coding that could change the column header to b all on the left side that way?

The coding will be attached behind a command button in access.

Any feedback would b greatly appreciated.
Mar 13 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,347
I don't know if there is a way to do this in Access (If you have a set number of rows AND columns a CrossTab query may work), but there is certainly a way to Copy/Paste the data from one type and transpose it to the other. Let me know if you're interested.
Mar 15 '07 #2

P: 14
I have transposed it by writing some code within the Excel file.
Not exactly the 'dream' solution I'd like to have....but as long as it keeps the users happy.... :D
Mar 16 '07 #3

NeoPa
Expert Mod 15k+
P: 31,347
I have transposed it by writing some code within the Excel file.
Not exactly the 'dream' solution I'd like to have....but as long as it keeps the users happy.... :D
That's fine.
Do you use the automatic Transpose option within the PasteSpecial facility?
Mar 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.