Batch append multiple CSV files to single Access 2007 table

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?
pinewoodyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
dim csvFile as string, csvPath as string

csvPath="C:\myCsv\"

csvFile=dir(csvPath & "*.csv")

while csvFile<>""
     docmd.transfertext acimportdelim,"spec_apps_import", "tblDownloads", csvPath & csvFile,True
     'delete csv file
     kill csvPath & csvFile
  csv=dir
wend


you can use this sample db for locating the csv files


ImportFileBrowser.mdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pinewoodyAuthor Commented:
wow. thanks for the fast response! will get on it...
0
Rey Obrero (Capricorn1)Commented:
did you get this working?
0
pinewoodyAuthor Commented:
nope. but no error messages, either, so i don't know what's wrong. another fire came up and i haven't been able to get back to it. thanks for the follow-up. i'm to get back to this project tomorrow AM.i'm sure there's something wrong at my end, something simple. i've exhausted all the high-falutin' possibilities. :)
0
pinewoodyAuthor Commented:
thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.