The_Kurgan
Active Member
- Joined
- Jan 10, 2006
- Messages
- 270
Greeting all!
I am using an Access (2010) macro to export a table to an Excel workbook via the ImportExportSpreadsheet function. I’ve used this many times in the past, but never had this issue. It appears that it appends the data to the old data and removes the old data. For example, if my old data ended on row 500, rows 2-500 would be deleted and the new data would start on row 501. Any ideas what I may be doing wrong?
I apologize if I should have posted this under Excel… was unsure which would be best.
Thanks in advance!
I am using an Access (2010) macro to export a table to an Excel workbook via the ImportExportSpreadsheet function. I’ve used this many times in the past, but never had this issue. It appears that it appends the data to the old data and removes the old data. For example, if my old data ended on row 500, rows 2-500 would be deleted and the new data would start on row 501. Any ideas what I may be doing wrong?
I apologize if I should have posted this under Excel… was unsure which would be best.
Thanks in advance!