Access getting data from Excel

[cinnie]

Every week, I get an Excel table delivered to me. I select the first 7
columns of 15 and paste them manually into an Access table with exactly 7
fields. There are typically 500 - 800 records. I know that's a bit retro,
but it works fine.

Now an new office helper will be on duty who has no background with
databases, so I'm somewhat reluctant to let him actually get anywhere near
the tables. What is a good, reliable and safe way to import this weekly data
into an Access database?

 

[AFSSkier]

One of the best ways to do this, is to do the following:
• Create a source excel file where the user can put the new source data.
• In Access, link to this excel source file (make sure the excel file
doesn’t change file location, name or the sheet name).
• Create an append query to append only the 7 fields of data into your main
Access table.
• Create a macro to run the append query.
• Create a switch broad for the new user to run the append macro.