Unanswered: Access export to Excel - Columns versus Rows
I have an MS-Access (2003) report, containing the usual data (customer name, address, etc., along with the products they've ordered) that I export to Excel (where I clean up some formatting problems). I then mail-merge the Excel data into an MS-Word document for mailing to customers.
My problem is that the product numbers export into separate Rows and I cannot pull them into the mail-merge. Is there a way to export them into Excel so they appear in separate columns? Then I could assign them separate column names and pull them into the MS-Word (mail-merge) doc.