title: Import 150 text files to Access as Tables using SQL
body: <p>I have 150 text files in csv format using pipe | as a seperator.  the files are in different folders on a network.  The filenames are date specific and have a suffix which holds the date. I have created a table which has 3 fields: File Location; File Name excluding suffix; suffix (in format yymmdd).</p>
  
  <p>I want to create an SQL script which will import each of the 150 files named in the table that I have created into 150 seperate Access 2007 tables named as the File Name excluding Suffix. I tried to do this using VBA but the filenames contain full stops and VBA didn't like this.</p>
  
  <p>Each of the files has a different column structure but the first row is always headers.  I can only use Features native to Access 2007 as the organisation I work for does not allow third party addons or applications.  I don't have SQL server available to me.</p>
  
  <p>I am a complete novice when it comes to Access and am struggling to achieve anything approaching this.  Can you help?</p>