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.
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.