Convert .DBF files to .MDB.....

  • Thread starter Thread starter Cagey Bee
  • Start date Start date
C

Cagey Bee

How can I use Access to convert a dBase IV .DBF file to an .MDB file? Exact
instructions would be helpful. I have Access 2000.

Also, can I convert Excel .XLS files into .MDB files?
Cagey Bee
 
How can I use Access to convert a dBase IV .DBF file to an .MDB file? Exact
instructions would be helpful. I have Access 2000.
Click to expand...

You can't, directly. A .dbf file is equivalent to an Access Table, one of many
objects in a typical .mdb file, and not to an entire .mdb file.

What you can do is to create a new Access database, and use File... Get
External Data... Import to import a dbf file into a (new or existing) table in
your database. Choose dBase IV from Files Of Type.
Also, can I convert Excel .XLS files into .MDB files?
Click to expand...

Same issue... just choose Excel instead of dBase.

John W. Vinson [MVP]
 
John W. Vinson said:
You can't, directly. A .dbf file is equivalent to an Access Table, one of many
objects in a typical .mdb file, and not to an entire .mdb file.

What you can do is to create a new Access database, and use File... Get
External Data... Import to import a dbf file into a (new or existing) table in
your database. Choose dBase IV from Files Of Type.


Same issue... just choose Excel instead of dBase.

John W. Vinson [MVP]
Click to expand...

Hey, it works! Thanks a million for such clear instructions!

Cagey Bee
 
Back
Top