Excel and Access project

Aug 28 2007 4:48 PM
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