Mr. B,
Thank you responding so quickly. I tried your updated code and it ran without error but when I pulled up the table itself only one line item had the filename:
-The file that had the filename was blank except for the "Batch Number" field and then my 4 test records were in the line...