Import Macro for multiple DBF files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have anumber of DBF files to import.
I have written a macro to import them but it only imports one at a time. I then have to go back into the macro and rename he source and destination files.

Is there any way to import all of the files at the same time using some kind of widcard naming convention
 
Hi Ian,

You can do this with VBA code but not with a macro.

For the general approach, see my recent post in this group under the
subject "Multiple spreadsheet import". Of course you'll need to
substitute a DoCmd.TransferDatabase statement for the DoCmd.TransferText
one.
 
Back
Top