How do I search CSV files with Access VBA (1 Viewer)

MS1234

Registered User.
Local time
Today, 06:29
Joined
Nov 28, 2016
Messages
17
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!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:29
Joined
May 7, 2009
Messages
19,169
here is a demo of what you described.
 

Attachments

  • TestSearchCSV.accdb
    964 KB · Views: 177

Users who are viewing this thread

Top Bottom