Importing .dbf File Into a Table Using Macro

M

meangene

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!
 
S

Steve Schapel

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.
 

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

[urgent] importing .dbf file 1
Macro to Import a DBF File 2
Create MDB, create Table in it and import a DBF 6
Importing FoxPro 2.6 DBF Into Access 2007 1
[urgent] importing .dbf files 2
Import dbf file 4
Access 2007 Import a DBF file 0
Macro Conditions 1

Top