Import 300 dbase IV files to one table

  • Thread starter Thread starter Cate
  • Start date Start date
C

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
 
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
 
Back
Top