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

[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

 

[B. Edwards]

In Access
File->Get External Data->Import->Select one of the dBase file types.

 

[John W. Vinson]

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.

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?

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

John W. Vinson [MVP]

 

[Cagey Bee]

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]

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

Cagey Bee