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...
Hello. I have a database which allows a user to import multiple .csv files at one time and adds them to a table. The file name format is based on the date and time including seconds which eliminates the possibility of duplicates since one person creates these throughout the day. Each file is...