Depending on if the txt file is well structured, but assuming it is, you can link the file to your database. Then use the linked file in an append query, with the right conditions, to transfer data to a native Access table. Or create a make table query if there is no native table yet.