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)

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.

Both of macro creating table, then put records into them.

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.

Excel file:
1 files , 8 colummns , 14000 records , it's like 110880 Cells(cells aren't empty)  

Time: 75 seconds.

P.S Everyfile have got another structure(number of colummns etc.). Everycolumn in Database have to be as Varchar(255)

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.)