Append Data TO Excel FROM an access table
Posted on 2014-03-28
Good Afternoon Guru's,
Here is the issue. We have a Spreadsheet.Worksheet that needs to be updated based off of 3 separate access tables.
The structure of the worksheet is 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....
The structure of the access table is:
field1 field2 field3 field4 field5 field6 field(Jan) field8(Feb) field9(March)
Fields 7 thru 14 are named as each month of the year starting with January.
What we need to do is place the values of each month from the access database to the appropriate cell in the worksheet.
So, using the naming convention above the process would be something like this.
Update column6(Jan) column7(Feb) etc.....
where worksheet.column1 = access.table.field1 AND worksheet.column2 = value1
How would this be done?
Going beyond the connection issue, that is no problem. The problem is how to dynamically put the values from the access table into the correct cell in the worksheet.
Thanks in advance !