ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File Error - Data May Be Lost message after Access export (https://www.excelbanter.com/excel-discussion-misc-queries/59034-file-error-data-may-lost-message-after-access-export.html)

Northpaw22

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



All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com