P
PeteProgAccess
I am running Access 2003 (although could use 2000 or 2007 if I had to) and
need to automate the import of data from an external source. The external
data is in a series of .csv files which are deposited into a folder on my pc.
If the file names never changed then all would be well, I could just link to
these .csv files but the names change each day.
Typically todays files will be called ImportA-10-22-2009.csv and
ImportB-10-22-2009.csv but tomorrow the files will be called
ImportA-10-23-2009.csv and ImportB-10-23-2009.csv.
So what I think I need to do is create a recordset of all of the csv files
in the folder so I can identify ones I have not already imported and then
create a link to each in turn so I can import the data.
Any ideas how I can do the two steps:
1. Making a recordset of external files in a folder
2. Linking to a filename that I have established in 1.
Any help would be much appreciated!
Thanks Pete
need to automate the import of data from an external source. The external
data is in a series of .csv files which are deposited into a folder on my pc.
If the file names never changed then all would be well, I could just link to
these .csv files but the names change each day.
Typically todays files will be called ImportA-10-22-2009.csv and
ImportB-10-22-2009.csv but tomorrow the files will be called
ImportA-10-23-2009.csv and ImportB-10-23-2009.csv.
So what I think I need to do is create a recordset of all of the csv files
in the folder so I can identify ones I have not already imported and then
create a link to each in turn so I can import the data.
Any ideas how I can do the two steps:
1. Making a recordset of external files in a folder
2. Linking to a filename that I have established in 1.
Any help would be much appreciated!
Thanks Pete