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

Access to Excel - fields across columns

P: 11
I have an MS-Access (2003) report that I export to Excel; clean up some formatting; and use the data in a MS-Word mailmerge for letters to customers.

In addition to the usual customer name, address, etc., my MS-Access report contains the products ordered by the customer. There could be anywhere from 1 to 10 product items (and their associated serial numbers) for each customer.

How, when I export the data, can I get the products into separate columns in Excel so I can include them in the mail merge. Currently they appear in separate rows and that screws up my mailmerge.

Thanks,

Krazy (Bill) Kasper
Sep 16 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi Bill. It is best not to export the report as such, since as you have found Access replicates grouping by introducing separate levels in the Excel sheet. I would suggest that you use DoCmd.TransferSpreadsheet to export a query based on the recordsource of your report instead. This will retain the normal row structure of the query concerned.

-Stewart
Sep 16 '08 #2

NeoPa
Expert Mod 15k+
P: 31,261
I very strongly support what Stewart has said about using queries or tables rather than formatted reports or forms to send data to Excel.

Having said that Bill, does this still leave you wanting to transpose some of your data from rows to columns, or would that be a full answer for you.

I have to say that if you're still after this we may well be getting into messy territory (if indeed it is practicable at all in your circumstances).
Sep 16 '08 #3

Post your reply

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