creativefusion
asked on
Loop through file path directory and write records to table
Hi All,
I have a static folder located in a directory that contains a dynamic number of csv files each of which contain exactly the same data. These files are updated daily automatically by an external system.
What I am wanting to do using access VBA is loop through the files and write the records contained in the files to a master table called DT_SKU_BY_LOC in MS Access 2002.
Has anyone got any ideas on how I could do this as quickly and efficiently as possible?
CF
I have a static folder located in a directory that contains a dynamic number of csv files each of which contain exactly the same data. These files are updated daily automatically by an external system.
What I am wanting to do using access VBA is loop through the files and write the records contained in the files to a master table called DT_SKU_BY_LOC in MS Access 2002.
Has anyone got any ideas on how I could do this as quickly and efficiently as possible?
CF
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent help. Cheers,
ASKER
Could you please point me in the right direction for an import spec?
CF