I have found several solutions to problems similar to my own, but I'm not competent enough to adapt to my situation. pls forgive me if i didn't browse deep enough.
i need to sweep a web folder for one or more CSV files, append them into a single Access table and remove them so that they don't get appended again in the next run.
the CSV files all have the same structure and include headers, the file names have definite patterns in that they all have a prefix and end with the date (apps_20100422.csv).
I do have an import spec called "spec_apps_import".
the CSV files have LOTS of fields in them, so I don't want to have to type all the field names, simply import all of them.
Can you help me get that code right?
I've tried Dir() but could not figure out the action req'd to import/append. i thought the SQL insert command would work, but all those field names stopped me.
thank you, in advance.
the name of the table they should go into is tblDownloads.
Oh, and the larger problem is that it won't always be me running this thing, so I need to have Access prompt for the directory (folder) that contains the CSVs.
Can this be done in Access 2007?