What kind of files? How do you want to import them? From where? What format are they in? Is there a pattern to their names? Where are they going? All into one table or separate tables, or something else entirely?
Originally Posted by Teddy's FAQ
In short, give us half a chance at actually being able to answer your question. Make it as easy as possible, and you're FAR more likely to get a response.
You are going to have to write some code to do that. Do you know VBA (Visual Basic for Applications)? If you do then you will need to do 100 docmd.TransferDatabase statements. You can get a list of all the DBFs by using the FileSystemObject.
If you know VBA and the above doesn't help that much I can provide some code. Otherwise it might be a manual process.