I am working on a project that uses both Access and Excel. The Access db I built contains relatively stable data (does not change much) but the Excel data will be replaced every month - its a monthly budget report (downloaded from a legacy app). The unmodified, downloaded spreadsheet is incomplete.
I want to build an application that will modify the Excel sheet by adding a column of descriptions based on the content of an adjacent cell within that same sheet. I will then need to add several rows to the top of the spreadsheet (6 rows) for the header information, which will be unique and also based on the content of a cell. the data for these two tasks will come from the Access database.
I have connected to the db and the spreadsheet and have been successful at creating a dataset. but now I'm not certain of what my next step should be. Any suggestions/help?
thanks,
Dave