Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data is rearranged when exported to Excel

Status
Not open for further replies.

BallunarCrew

Programmer
Sep 3, 2006
58
US
I have a parent table with two children. When I simply create a query and export it to Excel, I have what appears to be duplicate rows of the parent data due to the two children and the magic of the Cartesian products databases do for us. I need the Excel export to not show the duplicate data - blank cells in Excel are what we are after.
What I get:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
IADB Active MS Access Server1
IADB Active Visual Basic Server2
IADB Active MS Access Server2

What I want:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
MS Access Server2

I created a report with two sub-reports - looks great in Access - one sub-report next to the other. Export to Excel and it rearranges the sub-reports so the sub-reports are now on top of each other. I created a de-normalized temp table with as many child fields as possible based on the data - Language1, Language2, Language3, etc up to 44 since the max number of Languages per any app is 44. On the report, I stacked these fields as I want and did the same for the other child table. This report is great in Access but when exported to Excel, it unstacks them and puts them beside each other.
Bottom line - I want to Export to Excel and have Access not rearrange my data. Any ideas are greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top