Database Programming
Microsoft Excel
Microsoft Access

How do you add text files to a MS Access database?

202122

Answer

User Avatar
Wiki User
07/10/2007

There are two methods to add a text file to a MS access Database.
1) Link the text file. Go to File/Get External Data/ Link Tables. In the link file screen change the file type to Text file and then browse to the text file and select your text file. MS Access will prompt you to give the specs of the file when you are linking it. 2) Import the file to an access table. Go To File/Get external Data/ Import. In the screen change the file type at the bottom to text, and select your text file.