Please Help: Transferring Records to Backup File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M. Mentzel - 28 Jul 2005 02:41 GMT

I accidentally deleted an entire column (instead of a sincle record as I had
intended) of a database (let's call it database A) of over 4,000 records.
Fortunately I have a backup file (database B) but database A had been
expanded considerably since I last updated database B. I am going to keep and
update database B since it has the important column that I deleted. My
question is this: must I cut and paste the new records from database A to
database B one by one or is there a way to add these records in a single
action, i.e. export? I realize that this might be problematic since even the
new records in database A are missing an entire column of info but it would
still save me lots of time since there are probably more than 100 records.

Thanks for any help!

Reply to this Message

tina - 28 Jul 2005 06:33 GMT

please clarify what you did. databases don't have "columns". TABLES in
databases have columns, which are actually "fields" in the tables. did you
open a table in design view and delete a field?

perhaps we can salvage the situation without you having to abandon your
"expanded database A", if you provide more details - with correct
terminology so we can understand the situation clearly.

hth

> I accidentally deleted an entire column (instead of a sincle record as I had
> intended) of a database (let's call it database A) of over 4,000 records.
[quoted text clipped - 8 lines]
>
> Thanks for any help!

Reply to this Message