I used MS Access to do a file comparisons. I import and export data very often, but presently I been running into issues because the files I'm importing are too large and the queries are taking too long. I will like to start using VBA to performs this task. My present objective is to be able to filer a file before importing. Example I have a million records and have an indicator with A and B to be able to identify the record. My objective is to be able to import the file but I will only will like to import the A records. I know I could do a query, but this is a daily. Can guide me on writing a VBA code for this task.