title: The fastest way to import txt/xlsx files to Access by Macro
body: <p>I want to Import all files(txt or xlsx from folder)
  I Already Created macro to do it.
  ( All columns have to be as char)</p>
  
  <p>To Import txt files i generate schema.ini file.
  To import excel files i used sql but it was so slow, so i choosed another way.</p>
  
  <p>Both of macro creating table, then put records into them.</p>
  
  <p>Score:
  Txt files:
  18 files , every database have 4 colummns full of records.
  18 txt files had 249584 , it's like 969 688 cells.
  Time: 20 seconds.</p>
  
  <p>Excel file:
  1 files , 8 colummns , 14000 records  , it's like 110880 Cells(cells aren't empty)<br>
  Time: 75 seconds.</p>
  
  <p>P.S Everyfile have got another structure(number of colummns etc.). Everycolumn in Database have to be as Varchar(255)</p>
  
  <p>Btw:
  Do you know any good solution to export all database in Access to txt?
  Is it possible to check code page of txt files?( by using VBA or Emeditor.)</p>