Importing Text Files Into An Ms Access Database
In some of the MS Access databases that you develop, there may be a need to import data from text files, also referred to as ASCII files or flat files. Let’s look at the menu methods available to you.
Under the File menu, there is an entry named “Get External Data”, and then “Import…”. The extra “…” indicates that when you choose that entry, a dialogue box will appear on the screen to ask you for further details.
The next step is to change the “Files of type:” entry…