Importing .dbf File Into a Table Using Macro

Discussion in 'Access Macros' started by meangene, May 24, 2010.

  1. meangene

    meangene Guest

    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!
    meangene, May 24, 2010
    1. Advertisements

  2. Meangene,

    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.
    Steve Schapel, May 24, 2010
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.