Copy and Paste Data Into an Indexed Table

[CLT49er]

We have created a split database which allows my manager to update the data in the table on a weekly basis. The table is indexed in order to speed up time it takes to search for the records from the front end. Every week we have to add records to the access table from an excel spreadsheet. My manager likes to copy and paste the new records into the existing table. If we continue to add records to the indexed table via copy and paste, will the table automatically stay indexed or will this slow the response time down. Thanks for the help and the great resources.

[June7]

Copy/paste should not be an issue any more than typing the data into the fields. Some queries can get noticeably slower with large datasets, even with indexing. That is the nature of databases.