Upload textfile access for query?

I want to upload file to access for query.

Please guide me about it.


can you be more explicit on what you need please?


@fernando_zuluaga I have text file as attached.

textFile2.txt (8.3 KB)

But I want filter as below.

  • column BUSINESS_LINE that = IL only
  • column ช่อง2ช่อง3 = ช่อง 3
  • column APAPDT (Date) between 25650131 - 25650228 (format yyyyMMdd) yyyy = Buddhist era

finaly write data column AGNAME , APDOD ,APENDT , APSTDT , APSUM , APMOD in excel file.

Please guide me about it.

Any solution about this case ?