Uploading MS Excel Worksheet to MS Access

Question

Hi All,

I am trying to find the most efficient way to upload a MS Excel file (new one every month) into an ongoing MS Access table. I do not have MS Sharepoint and find it increasingly frustrating to go through the IMPORT WIZARD.

QUESTION: Is there a method for MS Access to import all the workbooks sitting under a specific directory? Is linking the tables a better option? AND if so, how do you go through this process.

I have exhausted all of my resources and knowledge in creating a "fool-proof' method for the data on my EXCEL sheet could be found on a safe Access Database..!

HELP!

Thank you guys!

Mikaila :)

Answer 1

A Google search for: "Access 2007" import all excel in a directory

Returns this amongst others: http://www.accessmvp.com/kdsnell/EXCEL_Import.htm

---

http://www.saberman.com

Answer 2

Saberman gave you a great resource.  Here's a few more:

http://www.erlandsendata.no/english/index.php?d=envbadacexportado

http://www.erlandsendata.no/english/index.php?d=envbadacimportwbado

Here's the main site:

http://www.erlandsendata.no/english/index.php?t=envbadac