• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1735
  • Last Modified:

dBASE III Plus .dbt file

I have a dBase database that I want to convert over to Access which is relatively easy but in one table there is one field where the programmer put all of the information for this field (from all the records) in a .dbt file.  What I was wondering was if there was a way through dBase or any other way that I could take the info from the .dbt file and put the segments in a table that I could use in my database.  I've never used dBase, so I would need step by step directions.
0
homan7
Asked:
homan7
  • 4
  • 2
1 Solution
 
TimCotteeCommented:
From memory, .dbt file is a memo file which contains information contained within one or more Memo type fields in the table.

If you import this table directly using the access import table routine, selecting the .dbf file then the memo fields should be created and populated correctly.
0
 
homan7Author Commented:
Tim,
  I tried importing the .dbf file directly from access and it sort of worked.  The field is diagnosis and every record should have a diagnosis but after importing it only about 5% of the fields have that field filled in.  The rest are blank.  Is there any other way to try this.  Can I list all of my records in dbase and then save that list as something else that I can import?
0
 
TimCotteeCommented:
If you want to send me the .dbf and .dbt file to TimCottee@earthling.net, I can have a look using foxpro/dbase and convert it to an access mdb for you.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
homan7Author Commented:
Tim,
  I would love to send you the files but they are about 20Megs each, and I work in a doctors office so the info is confidential.  I have foxpro and Paradox which I will try to import it to one of those formats and then I'll post a comment to let you know how it turned out.  Feel free to post if I should be doing it a certain way in foxpro or paradox.
0
 
homan7Author Commented:
Tim,
  I was just looking at your profile and you might be able to help me out more than you realize.  I am a beginner VB Programmer and what I was hoping to do was to get that database into Access becasue I know how to work with Access through VB.  Unfortunately though, I don't know how to work with FoxPro through VB.  Essentially what I want to do is to be able to search this database through VB + SQL to bring up specific records.  I'm not adding or deleting or editing any records.  I plan to print out selected info on a pre-made report template.  Like I said I already know how to work with Access Databases so learning how to work with FoxPro shouldn't be too hard if you can help me out.

0
 
homan7Author Commented:
Thanks Tim
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now