Simplest way to copy info from field to field in different record

  • Thread starter Thread starter RichN
  • Start date Start date
R

RichN

Windows 2000, Access 2002

Needing to fill in the blanks on a big table, one field in
about 1000 records needs to be filled in. Much of the
text is the same, why doesn't Access allow you to copy
from field to field. BTW, I know it's not an Excel
spreadsheet, but it does seem to be something folks would
be wanting to do. Or do I need to look at it in a
different way? Suggestions welcome
 
Depending on the size of the table you could copy and
paste into Excel to do your editing and then copy and
paste append back into Access (into an empty table)

An update query could also be a solution but you may have
to run it several times to complete your updates.
 
Thanks, Mark, but how safe is it to copy & paste append
back into Access? Seems like every time I try one of
these "big operations" (over 1000 records), it either
messes up or I have no idea if it's accurate
 
I can't give you any guarantees I'm afraid! But I've
copied and pasted 10,000 records into Excel and then used
Paste Append to take them back into Access without any
problems. This isn't recommended as a solution as it goes
against all the principles of having a database in the
first place, but it worked for me as a one-off.
 
Back
Top