HELP - Consolidating multiple excel files to 1 access db

[nikkai]

Hi

I posted this in the general database forum before I saw this forum. Sorry for the double post.

Is there a way to make a script that will consolidate 300+ excel files into one gigatic access database? (ie: Automated convert then append?).

Sample macros would be *HUGELY* appreciated.

Please email me an answer as I have no clue how I would find my own post again.

Thanks

 

[PHV]

In the Access VBA help take a look at the Dir function and at the TransferSpreadsheet and RunSQL methods of the DoCmd object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886