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.
homan7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TimCotteeHead of Software ServicesCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
TimCotteeHead of Software ServicesCommented:
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
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.