undo import

[TB]

Is there a way to undo an import once the data had been put in a table?
Thanks
TB

 

[Jerry Whittle]

A simple way like using an Undo button? No.

You MAY be able to import the data into another table then compare the two
tables. Delete the records that match.

I often put a Date/Time field in each table with a default of Now(). That
way I can tell when the records were entered. In the case of an import, you
might be able to tell which records by a similar field if the import data had
one.

 

[Gina Whipp]

TB,

No way that comes to mind but you can get creative...

1. Time/Date Stamp each record so you could pull those records out for
whatever reason
2. Import into a Temp table to review before pushing to your destination
table

Perhaps if we had more information on what you are trying to import and why
you want to back it out we could give you more suggestions AND/OR there
might be a way to *rollback* your transaction/import.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Is there a way to undo an import once the data had been put in a table?
Thanks
TB

 

[Jeff Boyce]

I'm with Gina ... more information please ...

For instance, if you were storing your data in a SQL-Server database, you
might be able to roll back/out the data.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.