Data Import Question

C

carl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top