View Single Post
 
Old 03-23-2012, 10:03 PM
MarvinP MarvinP is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2012
Location: Seattle, WA
Posts: 12
MarvinP is on a distinguished road
Default

Hi djreyrey,

The answer is:
Microsoft Access copies the exported data to the next available new worksheet in the workbook.
Found at:
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

This means you can't overwrite an old worksheet with the new data. You can rename or delete the old and rename the new worksheet.
Reply With Quote