By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,663 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,663 IT Pros & Developers. It's quick & easy.

Converting DBF to MDB

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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)
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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


Nov 12 '05 #5

P: n/a
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


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.