| | |
|
|
|
Copying data into multiple records |
|---|
| message from Lynn L on 27 May 2004 |
I have the same data that needs to be added to 4000
records. The standard copy and paste will take forever.
Is there anyway to copy and paste it to multiple records
at once?
|
| Brian Kastel replied to Lynn L on 27 May 2004 |
If those 4000 records are identifiable as a group by the data on another
field, you can create an update query with the data in that other field as
the criteria.
Hopefully, the "same data" you're trying to paste consists of foreign key
values you're adding to the table rather than duplicates of data you already
have in the table...
|
|
Archived message: Copying data into multiple records (MS Access Error Message)
