Multiple Records

[Christine Ronning]

Hi everyone,

I am putting a very large amount of digital data into a new structure. So
far I have been doing this by copy and pasting the data into a format in
Excel that fits into my tables in Access, and then copy and pasting it
directly into the tables.

I have been told I should be entering data through forms, but I can't see
how to add more than one record at once.
I there a way to do this, or should I just keep adding to my tables?

Thanks Christine

 

[Wayne Morgan]

Have you tried linking to the Excel sheet as an external table then using an
Append Query to import the data?