Data Import Question

I have data file (csv) located here in this path

J:\Billing\CSVs\Firm58

The files I am trying to import into a table are named like this

J:\Billing\CSVs\Firm58\BOX005_20110802.csv
J:\Billing\CSVs\Firm58\BOX005_20110803.csv

The last part of the file name is the Year/Month/Date. I would like to
do an import of all the files for August (BOX005_201108*)

The data is comma separated and I would only like to import the data
in "column" 2,4,18, and 19.

Is there a way to import these files via a macro or other means so
that I do not have to do the import 1 file at a time ?

Thank you in advance.