Please Help: Transferring Records to Backup File

[M. Mentzel]

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!

 

[tina]

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