Converting DBF to MDB

[Bugga Bugga]

I have been working on a database containing the verses from the Bible
and the figures of speech that apply to the verses. All but one of
the fields are text fields. There is one memo field that contains the
passage because I was not able to use a text field because some
passages exceed 254 characters.

The database was prepared using Lorus Approach 2.1 which is able to
export the file to dbf format. I now have Access 2000 and have been
trying to import or convert the dbf file to an mdb file. The best I
have been able to do is get Access to open it as a table. I also
tried exporting it to a text file and then importing it.

Is there any way that I can convert the dbf file to mdb. There are
32,000 records, so retyping them is not a good idea.

This is not a commercial database.

Thnaks

BB

[Lyle Fairfield]

Bugga Bugga <bu********@nomail.com> wrote in
news:o1********************************@4ax.com:

Is there any way that I can convert the dbf file to mdb. There are
32,000 records, so retyping them is not a good idea.

If you pray, won't God do it as a miracle?

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Phobos]

Run a "Make Table" query on the linked dbf file.

P
"Bugga Bugga" <bu********@nomail.com> wrote in message
news:o1********************************@4ax.com...

I have been working on a database containing the verses from the Bible
and the figures of speech that apply to the verses. All but one of
the fields are text fields. There is one memo field that contains the
passage because I was not able to use a text field because some
passages exceed 254 characters.

The database was prepared using Lorus Approach 2.1 which is able to
export the file to dbf format. I now have Access 2000 and have been
trying to import or convert the dbf file to an mdb file. The best I
have been able to do is get Access to open it as a table. I also
tried exporting it to a text file and then importing it.

Is there any way that I can convert the dbf file to mdb. There are
32,000 records, so retyping them is not a good idea.

This is not a commercial database.

Thnaks

BB

[Peter Russell]

Bugga Bugga previously wrote:

I now have Access 2000 and have been
trying to import or convert the dbf file to an mdb file. The best I
have been able to do is get Access to open it as a table.

Do this (say this linked table is called dbftbl.)

Then write a make table query based on tdbftbl or an append query which
appends all records from dbftbl to an existing table with the same
structure. (Sounds like a make-table query is what you really want,
first).

To create a make-table query create a select query which selects all
fields, then use the Query menu (with the query open in Design view) to
convert it to a new table.

Make sure you have a backup of your dbf file before you start.

Regards

Peter Russell

[Bugga Bugga]

Yep, That Worked.

Thank You Very Much

BB
On Sat, 27 Sep 2003 16:15:09 +0100, "Phobos" <la******@spammers.co.uk>
wrote:

Run a "Make Table" query on the linked dbf file.

P
"Bugga Bugga" <bu********@nomail.com> wrote in message
news:o1********************************@4ax.com.. .

I have been working on a database containing the verses from the Bible
and the figures of speech that apply to the verses. All but one of
the fields are text fields. There is one memo field that contains the
passage because I was not able to use a text field because some
passages exceed 254 characters.

The database was prepared using Lorus Approach 2.1 which is able to
export the file to dbf format. I now have Access 2000 and have been
trying to import or convert the dbf file to an mdb file. The best I
have been able to do is get Access to open it as a table. I also
tried exporting it to a text file and then importing it.

Is there any way that I can convert the dbf file to mdb. There are
32,000 records, so retyping them is not a good idea.

This is not a commercial database.

Thnaks

BB

[Bugga Bugga]

Thanks for the help. It worked.

BB

On Sat, 27 Sep 2003 16:29 +0100 (BST), pr******@russellscott.co.uk
(Peter Russell) wrote:

Bugga Bugga previously wrote:

I now have Access 2000 and have been
trying to import or convert the dbf file to an mdb file. The best I
have been able to do is get Access to open it as a table.

Do this (say this linked table is called dbftbl.)

Then write a make table query based on tdbftbl or an append query which
appends all records from dbftbl to an existing table with the same
structure. (Sounds like a make-table query is what you really want,
first).

To create a make-table query create a select query which selects all
fields, then use the Query menu (with the query open in Design view) to
convert it to a new table.

Make sure you have a backup of your dbf file before you start.

Regards

Peter Russell