Copy and paste cells in same table

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

Guest

I accidently entered a large amount of information into the wrong column for
a group of rows. I would like to copy the group of information and paste it
into the correct column. How would I do this. I tried copy and paste and it
will let me copy the group of cells but will only let me select one cell to
paste it into. This is way to much information to paste one cell at a time!
 
This is Not Excel! There are no Cells!
Sorry, but it is not going to behave like a spreadsheet. You will either
have to do it manually, one at a time, or consider creating a query that will
correct the problem.
 
I know about queries but don't know how to use them to fix a problem...would
you be so kind as to help me. Co
 
Sure, If I can.
I will need some info.
How do you know which rows had the incorrect data loaded into a column?
Where is the correct data you want put into the table and how will you know
which row it belongs to?

What we will try to do is create an Update Query that will put the correct
values in, but we need to know how th match up the correct data with the bad
data.
 
It might be easier to export the data from the table to Excel, fix it there,
then import it back in to a clean table...
 
Back
Top