[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1522
  • Last Modified:

How to export one to many relationships in excel

I have a table that I need to export that has a one to many relationship. Mainly notes

has anybody ever done anything like that? how to export in excel from 2 tables that have a one to many relationship?

thanks,
Vinnie
0
damixa
Asked:
damixa
1 Solution
 
andrewssd3Commented:
I think you'll need to give us a bit more information - are you looking to export access data using a join query into Excel? If so, what format are you expecting in Excel?  If you can give an idea of the data in the tables, and what output you expect, it will be easier to help
0
 
Rey Obrero (Capricorn1)Commented:
create a query that joins the two tables, export the query to excel.

if your tables consists of memo fields, you have to open the query as recordset and export the result to excel using vba..

post back if you need more help.
0
 
PatHartmanCommented:
What will the Excel workbook be used for?  If it is a report, you can write some code to export the many-side to additional columns rather than rows.  But if the workbook will be imported into another application, you either need to leave off the many-side data entirely or simply export the joined records which appear to "duplicate" whenever there is more than one many-side record.

If you are exporting to another application, you should also look into using XML which lets you export hierarchical data without "duplication".  But of course the target app needs to be able to accept XML for that solution to work.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now