Please Help: Transferring Records to Backup File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top