View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Northpaw22
 
Posts: n/a
Default File Error - Data May Be Lost message after Access export


After performing an append query on a list containing duplicates, I
exported the new table as a new sheet into a pre-existing Excel file
containing approximately nine other sheets.

When I click on the file to open it, I get an error message stating
File Error: Data May Be Lost. When the file opens, the first worksheet
appears to be fine, but the other nine plus the new one that I exported
from Access are jumbled as if the file had been corrupted.

I tried the "Open and Repair" option but to no avail. Is there
anything I can do to restore the data? I am an intermediate level
user, so nothing too programming-heavy, please.

Thanks,

Jamie


--
Northpaw22
------------------------------------------------------------------------
Northpaw22's Profile: http://www.excelforum.com/member.php...o&userid=29413
View this thread: http://www.excelforum.com/showthread...hreadid=491238