retaining data after linked excel is removed

[AxonIDI]

hi guys, i would like to find out if it's possible for access to retain or save the data that was in the excel right before it's removed or deleted...



i understand that if the linked excel file is moved to another location, we can just easily re-link the excel file through the linked table manager in access...

however, if the excel file is physically deleted, the values in the access table will become ERRORs... is there anything i can do to make it retain the data?

thanks in advance...

[June7]

Import to a table or run Make Table query.

[AxonIDI]

Import to a table or run Make Table query.

importing is manual work...

i wanna make changes to the excel and update the access

and

retain the data of the excel in access even if the excel is deleted

[June7]

The only way to retain the data is to save it to a table. That means import or Make Table.

[AxonIDI]

The only way to retain the data is to save it to a table. That means import or Make Table.

ahhhhhh... so there's no way to make it smart enough to save a snapshot...............

[June7]

The table IS the 'snapshot'. If you want to make a pdf image and save that somewhere, is another kind of 'snapshot', but that doesn't save manipulable data. All this can be programmed to perform at the click of a button. Access is only as smart as you program it.