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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't import dbase IV files 3
Import of dbase files 3
Importing DBase IV files 1
Dbase IV Import 1
Exporting to dbase IV 1
ACC2007: numeric fields truncated when imported from dBase III fil 1
Prob. Importing/Exporting dBase files 0
Error Message "Cannot define field more than once" 1

Back
Top