Importing .dbf File Into a Table Using Macro



I can manually import a .dbf file into Access (using Access2003) but cannot
find the appropriate Action commands to do the same in a Macro. I have a
shipping app that creates .dbf file when it performs an end-of-day and would
like to import this data into a table automatically every night instead of
doing it manually next morning. Thanks!

Steve Schapel


Use the TransferDatabase action. There is some information in Help about
haw to handle non-Access files - enter TransferDatabase in the macro design
window and press F1.

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