Import Macro for multiple DBF files

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
 
J

John Nurick

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.
 

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

Macro to Import a DBF File 2
Import DBF files with MEMO fields 10
Bulk Import DBF files to access 2003 1
Import a dbf database into existing access table? 2
Import / Export DBF Files 2
Importing DBF and appending to databse 3
can't import a dbf file 1
How do I import multiple .dbf files into Access 2007? 0

Top