DBF Record Import into Access 2000

M

Mike

I've consolidated numerous records from way too many days
of DBF files into Excel before Importing this into Access
2000, which works wonderfully (whether linked or not).
However other programs, like FileMaker Pro, allows
importing of records directly from the DBF file into an
existing Database Table.

How do I do this in Access 2000? I can Import the data
from each region for each day, but I can't find out how
to import the records directly from the DBF files into my
existing Master records table other than one record at a
time (way too tedious!!!). I cannot believe there's not a
way to handle this with only one master table within
Access. All other sources I've researched don't provide
any information about how to accomplish this, just
straight Importing and/or Linking of External Data to a
NEW Table.

Thanks,

Mike
 
J

Joe Fallon

Case "dBase 5.0"
DoCmd.TransferDatabase acImport, "dBase 5.0", strLocalDir,
acTable, strFileName, strTableName
 
M

Mike

Thanks, Joe.

I'm importing dBase 7.0 formatted files, so I'm off to
locate and install the BDE 4.x for compatibility.

- Mike
 

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

Import a dbf database into existing access table? 2
Importing FoxPro free table, getting around "the field is too small to accept.." error 1
Importing FoxPro 2.6 DBF Into Access 2007 1
How do I import multiple .dbf files into Access 2007? 0
how can I export an Access 2007 table to .dbf 1
Import DBF files with MEMO fields 4
How to import .DBF file into ACCESS 8
can't import a dbf file 1

Top