Greetings Access Experts,
I hope one of you has a fresh idea that can help me.
I am exporting multiple access tables to Excel. A few tables are in a 'many' relationship with my mainTable.
I need this data to export as a single row with the mainTable data as follows (all fields mainTable, all fields in first record manyTable, all fields in second record manyTable, etc.)
I developed a vba solution that is complicated (count, insert, create tempTable, append, load recordset, export) but works just fine.
I am curious if there is a simpler way to accomplish and maintain this function.
Ideally, I would like to perform this work using standard Access queries that the user can more easily manipulate if they choose to add or delete fields.
I thank you in advance --
CongoGrey