Multiple Records

  • Thread starter Thread starter Christine Ronning
  • Start date Start date
C

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
 
Have you tried linking to the Excel sheet as an external table then using an
Append Query to import the data?
 
Back
Top