Per RA:
I am wanting to upload 100+ seperate excell files to create and access
database.
Is there a way to write a macro to automatically import all of the
excell files contained within an folder?
The short answer is "Yes".
The long answer depends on what the workbooks look like, how
reliable their format is, and how good the data in them is.
Without knowing any of that, I'd say that if you're *really*
lucky you'll be able to create an ODBC link to a sheet that needs
tb imported and the consist ant format/data integrity of the
sheet will allow you just pull in the data as if it just another
table.
More likely, however, I suspect it will take quite a bit of VBA
code to validate the sheet's format, extract it's contents to
work tables, validate the data in the tables, and then copy same
into the MS Access back end.
If not, is there an easier way to do
this? The excell files need to be uploaded each month.
I do this all the time - but don't find it trivial by any means.
If somebody knows of an "easy" way to do it I'd like very much to
hear about it... -)
