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
    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
    #2
    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.