Access Query Results to Multiple Worksheets in Excel (1 Viewer)

[cds5819]

Apologies if this is being posted in the wrong forum. Here is my question:

I have an Access 2010 database, and a query which returns record information, like below:
Record Name Age Gender Street
123 John Smith 62 M 111 1st St.
124 Jane Doe 34 F 222 2nd St.
125 Bob Roberts 55 M 333 3rd St.

Is it possible to export these results to Excel so that each record is given it's own worksheet (Sheet 1 renamed to 123 and containing all the information for record 123, etc) ? I looked at the TransferSpreadsheet command, but that just seems to export the entire query. I'm sure this is either ridiculously easy (or just plain ridiculous), but I can't see to find a solution. :banghead: Any help or advice from you fine folks would be greatly appreciated. Thanks in advance.

 

[noboffinme]

Hi cds5819,

As this post was a little while ago, do you still want a response or have you reposted?

I'm working on the answer & am about 50% through.

I need to know if the 'Record_Id' value will ever be repeated.

If so, all info about any rows with the same 'Record_Id' are to be added to the same worksheet, is that correct? Otherwise, you will have multiple worksheets
with only one record on them which doesn't seem useful to me.

Let me know & I can complete it, Cheers