I have an CSV file which is created each day for the previous days information. I need to include this file name within an SQL statement I am writing which will be compiled to be used in an Access 2007 database. The data in the CSV file needs to be imported into an Access Table and I would prefer not have the users have to manually do the import I want to create a button which would import the data. The file is named YYMMDDHHMMSS_Time DetailMMDDYYb.csv. How can I write this within the SQL statement so when the user enters a date the program will know to pick up the correct file. I can have the users entered the date as MMDDYY when prompted for the date to be imported.