Conditional Import

Question

I have 300+ flat files. I am importing/loading them using

LOAD DATA LOCAL INFILE 'D:\\MxxT\tot2098.TXT'
  INTO TABLE Twenty.F98
  FIELDS TERMINATED BY '' lines terminated by '\r\n' ;

on my MySQL Server database.

Each of 20 files makes 28 tables. I have a flag variable which is MachineType in all flat files. After import of 20 files. I have to do

SET SQL_SAFE_UPDATES=0;
DELETE FROM Twenty.F98 WHERE MachineType <>1;
SELECT DISTINCT MachineType FROM Twenty.F98;

1. Is there any way I can place a condition when loading data file?

2. In MS Access I have used Schema.ini which loads the files in a second or less. Is there such mechanism available for MySQL?

3. I have to create a dashboard after loading of all files. I am thinking of Using Excel as front end. Is there anything else better than that?