I assume you are using TransferSpreadsheet to export the data, correct?
On my website (www.rogersaccesslibrary.com) is a small sample database called " ExportToExcel.mdb
" which illustrates how to do exactly this. There is also a 7 page document included which gives detailed explanation.
The trick here is that you have to have a Named Range in your data tab that is the same as the name on the tab. When you export to that name, then it will over-write the cells in that tab. The easiest way to create this named range is to delete your datatab, then export your data. It will create a new tab with the correct name AND the correct named range. The next time you export, it will find the right tab.