Link or import

[jiminy]

I have an Access DB of personnel-type info. The info originates online in different Excel files that are updated on different schedules. Each is renamed according to the date it was last updated. I cannot link the online files to the DB, so I have to save them to my computer and link or import them from there.
I am trying to decide whether it it is more practical to link files to the database or to import them. Any ideas?

 

[dhookom]

I typically import. It might take more work initially to import, manipulate, and update tables but I find it is more efficient to work with data in tables.

Duane
Hook'D on Access
MS Access MVP