Apologies if this has been asked before, I have searched on the site, but no luck so...
with transferspreadsheet method you cannot overwrite an existing tab in an Excel worksheet,
eg.
worksheet has a tab called pupil_data
if you export the data again from access a new tab is created called pupil_data1
is there any way to have the data overwrite the existing tab rather than adding a new one?
ta
John
with transferspreadsheet method you cannot overwrite an existing tab in an Excel worksheet,
eg.
worksheet has a tab called pupil_data
if you export the data again from access a new tab is created called pupil_data1
is there any way to have the data overwrite the existing tab rather than adding a new one?
ta
John
