If you simply want to view the latest source data within Access for richer querying and reporting, create a link to the text file in your database by using the Link Text Wizard.
This article explains how to import and link to a text file by using these wizards.
If you want a copy of the data that you can edit within Access, import the file into a new or existing table by using the Import Text Wizard.
When you link to an Excel worksheet or a named range, Access creates a new table that is linked to the source cells.
Any changes that you make to the source cells in Excel are reflected in the linked table.
For more information about linking to text files, see the section Link to a text file, later in this article.
During the import operation, you can specify whether the file uses a qualifier and, if so, specify the character that acts as the qualifier.