How to import multiple dbf files in one file

[Controller]

Hello all!

I have 365 dbf file (one per day) and I need to import all of them in one Excel file. Doing it manually is horrible.

Can somebody post a macro to import all the files automatically?

The dbf file names are in the form yyyymmdd.dbf.

I have searched both Google and this forum unsuccessfully.

Thanks a lot!

 

[Mark W.]

Why not just use the Data | Get External Data... menu command?