Adding Records to an Access Table

I want to run a query that on click will look at a file and add records based on the values in that file.
I have a file called example.txt  

the values of the file are like this


The database is called productlabels. The table is called mlabels.
In this table is the columns
Id (this is an auto number)
pi (this is a text value column)
col_id (this is a text value column)
col_description (this is a text value column)

I want the query to read and add the value "463" to column 2 (pi) "BEI" to column 3  (col_id) "BEIGE" to column 4 (col_description) as the last value was 10 I want it to create 10 records of this value. Then it should do the same for the next line but that has 15 records as you can see in the file and likewise for how many entries are listed in the text file.
In completion of the query if the file name can be renamed to example_done.txt
This is to avoid if the action query is run again it will not create a duplicate of those already added.

I am hoping that the query on running would the table be like this;

1  463 BEI BEIGE
2  463 BEI BEIGE
3  463 BEI BEIGE
4  463 BEI BEIGE
5  463 BEI BEIGE
6  463 BEI BEIGE
7  463 BEI BEIGE
8  463 BEI BEIGE
9  463 BEI BEIGE
10  463 BEI BEIGE
11 454 BLK Black
12 454 BLK Black
13 454 BLK Black
14 454 BLK Black
15 454 BLK Black
16 454 BLK Black
17 454 BLK Black
18 454 BLK Black
19 454 BLK Black
20 454 BLK Black
21 454 BLK Black
22 454 BLK Black
23 454 BLK Black
20 454 BLK Black
21 454 BLK Black
22 454 BLK Black
23 454 BLK Black
24 454 BLK Black
25 454 BLK Black
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Try this sample

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Try this sample
GenieMasterAuthor Commented:
Dear ASL315,
Thanks. What you did was perfect and just what I needed. Could not ask for any better. Brilliant. :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.