If you want to import a file that might change later, you might be better off creating a dynamic link to that file than importing it outright. With a link in place, if the file changes later, the changes will be reflected in the file imported into Access.
Don't use this procedure unless you are sure you need a link, rather than a simple import. Having a link in your database slows Access down when it opens a file.
Follow these steps to create a table in Access that's linked to an external file:
Select File, Get External Data, Link Tables. The Link dialog box appears.
Change the drive or folder if necessary.
Select the file type from the Files of type drop-down list.
Double-click the file name to open the file ...