I have a system that imports a number of pipe delimited files into Access. The names of these can vary and I do not want the users to have to rename into a consistent naming structure to manage the import process. Due to a new file being introduced, I need to be able to pick out all files of a type based on the number of columns in the file (greater than or less than 40 is sufficient at this stage).
Is there any way to look at a file before it is imported and count the columns?
Kelvin
Start Free Trial