Hi all
Im having a trouble doing this small project for work...
Basically what I have is 13 Folders (Names Vary) with roughly 150 Spreadsheets in each, all have the same layout. I would like to import all the files in the 13 folders to one table in access so I can various querys/reports.
This needs to be done on a monthly basis..
What is the best way to do this?
Im quite the begineer to access so please leymen terms only please.
Thanks in advance for your help!
PS this is Office 2000