Hi all,
The folks down in accounting (god bless them) have decided that rather than let Access handle their needs, they will still use Excel. Problem is, everyone else is now using my neat new Access database. I've made a query from 3 different tables of the data accounting needs. The problem, is that accounting has an existing Excel document Vouchers.xls and they want the Access query "AccountingExcel" to merge into the existing spreadsheet. When I try to do this, all I can do is have access override the existing spreadsheet and replace it with only the query results. I need the query to append to the sheet, not replace it. Any thoughts/suggestions would be helpful, I need a better job.
-Fort
The folks down in accounting (god bless them) have decided that rather than let Access handle their needs, they will still use Excel. Problem is, everyone else is now using my neat new Access database. I've made a query from 3 different tables of the data accounting needs. The problem, is that accounting has an existing Excel document Vouchers.xls and they want the Access query "AccountingExcel" to merge into the existing spreadsheet. When I try to do this, all I can do is have access override the existing spreadsheet and replace it with only the query results. I need the query to append to the sheet, not replace it. Any thoughts/suggestions would be helpful, I need a better job.
-Fort