Import "Contacts" Tables from 500 MDBs

[Patrick A]

All,

Can anyone point me towards the easiest technology or technique for:

Importing a table with the same name (Contacts) from 500 different
databases, all with different names. (I am in control of what the MDB
will be named, so I could name them 101.MDB, 102.MDB, etc.)

I'm an intermediate Access user, and I'm reading posts now to see if I
can find the answer, but there's a wealth of information, and I have
someone standing outside my door tapping their foot.

If anyone can point me in the right direction, I'd appreciate it.

Thanks,

Patrick

[Patrick A]

Thanks, Guys -

In the end, it turned out it was easiest to have the export done in
ASCII Windows format, resulting in numerous text files, and then
dusting off the DOS "copy" command to copy them all together into one
file, then import the file into a table in Access.

Thanks again.