Thank you I managed to solve it in this way. Keeping one table for the import and then move the wanted data into a new table where I created the...

Sorry, for the poor quality of the post. The problem is that the first row of the import (txtfile) is data that I dont want to keep, so I cant...

Thanks for the reply. I used the import wizard to import the txtfile. I will need to import the txtfile daily so it will sadly be a recurring issue.