[AccessD] exporting one to many tables into flat file

[John R Bartow]

I have a project where I need to export some of the data from a relational
database (MDB) to a comma delimited file for import into web based CRM
program which utilizes a flat file. The client data will now have one row
with a "tag" field for each organization that it is related to (some of
these clients are linked to hundreds of organizations). I'm l looking for
suggestions on how best to approach this:

 

Client 1toM > Phone > Mto1 PhoneType

Client 1toM > ClientOrg <Mto1 Organization

 

Thanks in advance,

John B