Hi, I have multiple CSV files in a folder, some of them have a column heading "Employee", some of them don't.
I want to click a button in Access that will search through the list of CSV files and return the name of the first CSV file where it finds the "Employee" column heading.
I don't want to have to import the CSV files into Access, I just want the VBA to search for the column heading and tell me where it finds it.
Thanks!
I want to click a button in Access that will search through the list of CSV files and return the name of the first CSV file where it finds the "Employee" column heading.
I don't want to have to import the CSV files into Access, I just want the VBA to search for the column heading and tell me where it finds it.
Thanks!