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]

Re: Converting DBF to MDB

Bugga Bugga <buggabugga@nom ail.com> wrote in
news:o19bnvgeda tvls26dj66q6ljh e6qoefpjt@4ax.c om:
[color=blue]
> 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.[/color]

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

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

[Phobos]

Re: Converting DBF to MDB

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

P


"Bugga Bugga" <buggabugga@nom ail.com> wrote in message
news:o19bnvgeda tvls26dj66q6ljh e6qoefpjt@4ax.c om...[color=blue]
> 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[/color]

[Peter Russell]

Re: Converting DBF to MDB

Bugga Bugga previously wrote:
[color=blue]
> 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.[/color]

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]

Re: Converting DBF to MDB

Yep, That Worked.

Thank You Very Much

BB


On Sat, 27 Sep 2003 16:15:09 +0100, "Phobos" <laughing@spamm ers.co.uk>
wrote:
[color=blue]
>Run a "Make Table" query on the linked dbf file.
>
>P
>
>
>"Bugga Bugga" <buggabugga@nom ail.com> wrote in message
>news:o19bnvged atvls26dj66q6lj he6qoefpjt@4ax. com...[color=green]
>> 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[/color]
>[/color]

[Bugga Bugga]

Re: Converting DBF to MDB

Thanks for the help. It worked.

BB



On Sat, 27 Sep 2003 16:29 +0100 (BST), prussell@russel lscott.co.uk
(Peter Russell) wrote:
[color=blue]
>Bugga Bugga previously wrote:
>[color=green]
>> 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.[/color]
>
>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
>[/color]