What are the downsides of linking tables to a DB (as opposed to just importing the data and keeping it there)? These tables are all excel files. Does anyone have any advice on whether it's better to link tables to DB or to import them? I'm working in an environment where there are many, many excel files that should all be talking to one another and should be more easily manipulated. (Hence, my efforts to create a DB that'll do this.) However, I can ask users to a) continue updating excel files as they have been and link the spreadsheets to the access DB, or b) create a way in access to import data and then tell the users to import the data into access. My concern with option A is that an excel file could be accidentally be deleted or the data could be easily messed up (whereas with the access DB, I'm going to add some security). Also, I'm afraid of the DB losing connection with any of these excel docs... or something weird like that happening. My problem with option B is only that it's more time consuming (for me) and that my users will need to create a new habit. Thank you very much in advance!!