Importing Multiple Spreadsheets all at once

[oshlonger]

Hello - I've been working on a project that involves manually importing a spreadsheet every day into Access. When I import the data, I append it to a single table. So ultimately, I end up with one table that grows every day.

The spreadsheets that I import are automatically generated each day and put into a single directory. The only thing that changes is the name of the file each day (filename-YYYYMMDD.xls)

I would think that there is a way to automate the importing of the spreadsheets or to set up something in Access where I can click a button and have Access go out and grab all the spreadsheets at once - I could do this weekly or monthly and not have to worry about/waste time importing spreadsheets manually.

Can someone offer some comments as to where I need to begin with this. I want to know first if this is possible. If it is, where should I begin? Can someone point me in the right direction or give me a high level overview of how I should try to accomplish this.

I'm no expert in Access, but I'm thinking this would involve some VB code. I'm having a tough time figuring out if this is possible, and if so, where to begin.

Thanks!

 

[Remou]

This:
Linking to a csv file that is named differently each day
thread705-1282134

Is a similar idea. You will quite a few posts on this topic, if you do an advanced search on these fora.