Hello guys,
I established a connection from my MS Access DB to an Excel-File and want to open it via a Button with VBA. That works.
I want to export some queries from MS Access to Excel (this also worked fine so far) but here is my problem:
The queries have multiple recordsets with the same ID from a table (that has been selected so it is included in the query). It kind of looks like this:
ID = 1, Entry 1 BUT I want to have it automatically changed in the Excel-Sheet so that it looks like this:
ID = 1, Entry 2
ID = 1, Entry 3
ID = 2, Entry 4
ID = 2, Entry 5
ID = 2, Entry 6
...
BUT I want to have it automatically changed in the Excel-Sheet so that it looks like this (all entries in one cell, so that ID is only shown once). I Also want to merge several appropiately changed queries in registers to one Excel-register that matches with the same ID. Is there a problem to that?
ID = 1, Entry 1
Entry 2
Entry 3
ID = 2, Entry 4
Entry 5
Entry 6
I'd be grateful for all helpful advise Thank you guys, you are doing a tremendous work!
Greetings,
FinisherProgrammer21