Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

MS Access 2007, paste into multiple records at once?

I have a DB I use with unique records but some times I need to copy a value from one record and then paste it into multiple records. Is there a way to do this?

For example. I have several shovels of different sizes and half are red and half green. Since all the shovels have their own record I need to paste the same color into several at a time instead of arrowing down and pasting 20 or 30 times.
0
REIUSA
Asked:
REIUSA
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
You should, as long as you paste it into a table that is exactly the same schema, without any AutoNumber columns or columns that are Indexed with no duplicates.
0
 
aikimarkCommented:
copy the data into Excel
use the fill down feature to populate your columns and duplicate rows
copy/paste the data back into Access.
0
 
SteveCommented:
Writing an Update Query to change Null values to the right value based upon your criteria would be safest as you can be clear about the criteria and check records affected before doing the update.
The Query could then be saved for future use.

Or as aikimark says, prepare the whole record in excel and then paste to Access.
0
 
REIUSAAuthor Commented:
Thanks, that worked. Initially I tried copying a cell and highlighting several more and it would only paste into the first cell but copying several cells from Excel and then highlighting and pasting them into Access worked. Weird.

Any idea why it will work from excel but not from another "cell" in Access? If I remember correctly previous versions before 2007 would let you do that.

Thanks for everyones help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now