I cut and pasted code that I use to import text files as an example of how to import text files.
I created a test table and renamed the field "Data" to "ImportData" since "DATA" is a reserved word in Access.
I created a from and added two buttons - one to import the text file and one to clear the test table.
If you have questions about the code, post back.
Also, I
MUST stress that a table has no order. It is a bit bucket. There is no guarantee that the order that you input the data will be the order that you read the data. You need another field that allows you to ensure the data can be read in the correct order.