B
BJM
Each week I must import data from csv text files to five
tables in my databse in order to update their records.
Having to go through the process of Get(ting) External
Data....with all the wizard's steps, five times over is a
pain.
Is there any way I can write a macro/event that will
facilitate this chore?
The text files are always found on the same path relative
to the database, and the wizard options are always pretty
much default and remain the constant week to week. The
field names in both text value file and destination table
are alike...no mapping necessary.
Thanks,
BJM
tables in my databse in order to update their records.
Having to go through the process of Get(ting) External
Data....with all the wizard's steps, five times over is a
pain.
Is there any way I can write a macro/event that will
facilitate this chore?
The text files are always found on the same path relative
to the database, and the wizard options are always pretty
much default and remain the constant week to week. The
field names in both text value file and destination table
are alike...no mapping necessary.
Thanks,
BJM