473,320 Members | 1,802 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Converting DBF to MDB

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
5 23033
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: mustafa | last post by:
Dear sir , I have built my application in visual basic 6.0 and crystal Report8.5 , Now i migrated my application to VB.net using the upgrade wizard.My visual basic form is upgraded to vb.net...
29
by: Armand Karlsen | last post by:
I have a website ( http://www.zen62775.zen.co.uk ) that I made HTML 4.01 Transitional and CSS compliant, and I'm thinking of converting it into XHTML to learn a little about it. Which XHTML variant...
8
by: prabha | last post by:
Hello Everybody, I have to conert the word doc to multiple html files,according to the templates in the word doc. I had converted the word to xml.Also through Exsl ,had finished the multiple...
5
by: Robert | last post by:
I have a series of web applications (configured as separate applications) on a server. There is a main application at the root and then several virtual directories that are independant...
3
by: Mary | last post by:
Hi, Does anyone know of any software out there that would convert an application written in VBScript to either VB.NET or C#/C++ quite quickly for me, or will I have to re-write the application...
2
by: Map Reader | last post by:
Greetings, I am converting an old VB6 application to use .NET. One of the old controls loads icons from the disk and displays them. However, the transparent color turns to blue somewhere in the...
12
by: Frederik Vanderhaeghe | last post by:
Hi, I have a problem converting text to a double. Why doesn't the code work: If Not (txtdocbedrag.Text = "") Then Select Case ddlBedrag.SelectedIndex Case 0 Case 1
7
by: Tor Aadnevik | last post by:
Hi, I have a problem converting values from Single to double. eg. When the Single value 12.19 is converted to double, the result is 12.1899995803833. Anyone know how to avoid this? Regards...
4
by: gg9h0st | last post by:
i'm a newbie studying php. i was into array part on tutorial and it says i'll get an array having keys that from member variable's name by converting an object to array. i guessed "i can...
2
by: shenanwei | last post by:
DB2 V8.2 on AIX, type II index is created. I see this from deadlock event monitor. 5) Deadlocked Connection ... Participant no.: 2 Lock wait start time: 09/18/2006 23:04:09.911774 .........
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.