Re: Convert .DBF files to .MDB.....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:gjskg39bce45lcte1f9h1a1ki22tpi0as8@xxxxxxxxxx
On Mon, 8 Oct 2007 12:01:23 -0400, "Cagey Bee" <nobody@xxxxxxxxxxx> wrote:

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]

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

Cagey Bee



.

Relevant Pages

  • Re: error 3011 when i would like open a .dbf to import in access.
    ... I try this solution and it works so this hint resolve only a half of my ... name of my dbf file when i would import the table in access. ... But in access database the problem is the same. ... I do not if this because we need another drivers or setup to work, ...
    (microsoft.public.access.externaldata)
  • Re: error 3011 when i would like open a .dbf to import in access.
    ... >name of my dbf file when i would import the table in access. ... But in access database the problem is the same. ... >> One thing to try is to use the shortname aliases that are automatically ... >> Please respond in the newgroup and not by email. ...
    (microsoft.public.access.externaldata)
  • Re: Convert .DBF files to .MDB.....
    ... A .dbf file is equivalent to an Access Table, ... objects in a typical .mdb file, and not to an entire .mdb file. ... What you can do is to create a new Access database, ... Choose dBase IV from Files Of Type. ...
    (microsoft.public.access.gettingstarted)
  • Problem connecting to DBF files using ADO
    ... I need to open a DBF file and use it contents in a application. ... So i created a new Access database an created a linked table to the DBase file. ... Regards, Ben ... Prev by Date: ...
    (borland.public.delphi.database.ado)