Append Data TO Excel FROM an access table

Dynamically?  Do you mean some kind of a live link, or code to select the data in Access and then export it to the workbook?

Yes, that is correct.
As values in the workbook.worksheet.column1 will "come and go".  For example, there may be a value of XXX in column one for the month of Jan, then in Feb the value of XXX would be 'gone' or 'decommisioned'.  Also, a value in  workbook.worksheet.column1 may NOT be there on Jan, then, in Feb a value of, say, f"oo" would be added.

Calculations are being completed on the access side in regards to Jan, Feb, Mar, etc... fields and these values from the DB need to placed ONLY in the column that matches,
for example:
The first column in the worksheet is being used as the data to match that of the first field in the DB.

 so,            DB.Field1 = worksheet.workbook.column1

DB.TableName.Field(Jan) would be placed in Workbook.worksheet.Grp1.Value1.Jan
and
DB.TableName.Field(Jan) would be placed in Workbook.worksheet.Grp2.Value1.Jan
and
DB.TableName.Field(Jan) would be placed in Workbook.worksheet.Grp3.Value1.Jan
and so on...

Does that help?

That looks like you could use MS Query to pull the data from Access and have it update each time. I suspect this would pull individual lines rather than Summary per line.

Or you may be able to use a Pivot Table with the Access table as the source data.

Thanks
Rob H

Yes, that is correct, a pivot table is being used.  However, I am having a time mapping the data from the 3 DB data sources and "matching" that data to where, or which cell that data will go to on the excel side.

Does your pivot link directly to the database or are you capturing the data into an excel sheet from which you are creating the pivot?

If doing it directly, the data link for the pivot should align the columns correctly.

I know you can create a pivot from multiple sheets within the workbook but don't know if you can with multiple external database tables.

Thanks
Rob H

The pivot table data is completed in the DB with a query.  I think the main issue is getting lost.  Let me refer back to the orginal question.
so, there is a worksheet that is structured like this:

column1     column2   column3    column4   column5   column6(Jan)       column7(Feb)

Grp1             Value1                                                         celltoupdate       celltoupdate
Grp1             Value2                                                         celltoupdate        celltoupdate
Grp1             Value3                                                          celltoupdate        celltoupdate
Grp1             Value4                                                              etc...                 etc....
Grp1             Value5
Grp1             Value6
Grp1             Value7
Grp1              Value8
Grp1              Value9
Grp1              Value10
Grp2              Value1
Grp2              Value2
Grp2               ECT...
Grp2
Grp2
Grp2

Problem:  I need to get query results from the DB to the excel sheet.  
Say "Value1" from each "Grp", being Grp1, Grp2 and so on,  is going to be an aggregate number that indicates "headcount".  In the DB these results are shown all in order.  Now say, the second query in the DB is going to fill "Value2" of Grp1, Grp2 and so on in the worksheet and this value denotes 'the total amount of money use for a period of time.  Now say, a third query in the DB is going to grab "projected budget" for "Value3" of Grp1, Grp2 and so on.
Does this help in explaining the issue.  We need to merge the data from the DB and put it into a certain order in the spreadsheet.

Does that help explain things a bit.  And by the way, I certainly appreciate your help and assistance, this one is kicking my bum.

So you are using a query within the database to combine the 3 tables and showing the required results in one query result table.

You could then use MS Query within Excel to pull the results of that query into Excel but that would probably give all lines of the query result so if the Pivot Table links directly to the query result it will summarise as required.

The Pivot table can be formatted such that it repeats row headers so it ends up looking like the table you are describing.

Are the Jan to Dec entries numeric values?

Thanks
Rob H

Umm, that's getting closer,

 Q.      ......"So you are using a query within the database to combine the 3 tables and showing the required results in one query result table....."

 A. No, there are about 20 queries that get reduced to 3 mutually exclusive queries, then the result set from each of the 3 queries 'get's placed' into the pre-formated worksheet.

I am somewhat bright about access and about totally stupid with excel.

Question:  Would be possible to dump the results from each query into a separate worksheet within the workbook, then from within excel combine the separate outputs in that fashion?

Come on experts, is this one that hard, or impossible?  Please let me know and I will throw in the towel.  There really is not to much time to miander about and my blood pressure is seathing.....

Anything I can do to help assist, please let me know.

UserName935, apologies that I was not able to keep up with your time expectations; your comment asking if this was impossible was received in my UK local time just before 10:00pm; well into the evening and just before bedtime so I was not in a position to respond further.

I know EE prides itself in speed of responses but we are all volunteers on EE and I don't know about other experts but I do have a day job to deal with as well so I pretty much deal with questions that I am monitoring in my break time but was not able to look at this until lunchtime.

Maybe if you had expanded on the detail in the first place, like you did with your comment 39966982 then maybe it could have been dealt with quicker.

However, it sounds like you have been able to find the resolution yourself, which is good as every day is a learning experience.

Regards
Rob H

Good Afternoon,

Relax, it's all good.

Sunshine and Light.

Thank you,

I figured it out.