title: Make new table with every CSV import-MS Access
body: <p>Is it possible to make table everytime a CSV is imported? I have 4 tables imported from CSV's with different names and I have created a new table(<strong>Reporting</strong>) out of them using a make table Query. Now I want to delete the 4 Tables and import 4 new CSV's and make another new table out of them say (Reporting 2) and I want to continue the process to make more Reporting Tables. I have tried with a code But I cannot seem to get a new Reporting Table Everytime. Where am I going wrong?</p>
  
  <pre><code>SELECT WebLife_Statistik.Antragsnummer, [WebLife_Statistik.Datum] &amp; "-" &amp;     [WebLife_Statistik.Zeit] AS [Ausgang Datenstrom WebLife], [ZW_Testdaten.Datum] &amp; "-" &amp; [ZW_Testdaten.Zeit] AS [Eingang Datenstrom Z-Workflow],     [Vs_anlage_schwebe.Datum] &amp; "-" &amp; [Vs_anlage_schwebe.Zeit] AS [Anlage Schwebe VSL], [Vs_annahme_police.Datum] &amp; "-" &amp; [Vs_annahme_police.Zeit] AS [Policierung VSL] INTO Reporting
  </code></pre>