Import 300 dbase IV files to one table

[Cate]

I am trying to import 300 dbase IV files into one table.
They each come in as a seperate table. If I save them as
excell files I get the import wizard and can add them to a
table. Any help out there?

Cate

 

[Joe Fallon]

Write code.
Put in a loop to read each file.
Pass correct variables to this:
DoCmd.TransferDatabase acImport, "dBase 5.0", strLocalDir, acTable,
strFileName, strTableName