I need to import several .csv files into one table in Access, but one of the key fields I need to use to identify the relevant records from the .csv file is only held in the filename and not within the data inside the file. Is there a way to extract part of the filename and add it as a field in Access when the file is imported?