Delrina Perform to DBF and DBT and then into Access

Hi guys,
       I'm currently overhauling a companies service system. They are at present using delrina perform. I've designed the new system in Access and what I want now is to import all the old records into an access table so I can use it in the new system.
Now Delrina allows you to export to a dbase file, .dbf and also for this project exports a .dbt file containing all the memo fields of which there are about 5.
I'm banging my head against the wall at the moment trying to import this data. I've used a few dbf viewers to look at the .dbf file and they give the memo fields a length of 10 and don't link to the .dbt file. I've looked in the .dbt file using visual studio and I can see all the correct info is in there but I can't seem to find anything to link the .dbf and the .dbt together at the moment and allow me to import that into access.
I look forward to your ideas
cymru_cowboyAsked:
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.

CarlWarnerCommented:
How to use dBASE data with Access and Jet
http://support.microsoft.com/default.aspx?scid=kb;en-us;230125
0
cymru_cowboyAuthor Commented:
Hi carl,
        I looked through the link you provided and it doesn't seem to help much. I'm running xp sp2 so I've got the latest jet engine installed already.
Cheers for the comment though.
0
CarlWarnerCommented:
Sorry, I really gave you the wrong link, even info about Jet is just fine. :)
0
Powerful Yet Easy-to-Use Network Monitoring

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

CarlWarnerCommented:
Use this link, even though it still is not the one I originally intended to post.  Wherever it says Visual FoxPro, just substitute and use the word dBASE instead.  The concepts are the same within the MS Access environment.

ACCESSING YOUR VFP DATABASE IN ACCESS
http://www.foxite.com/articles/032.htm

Visual FoxPro uses its own flavor of dbfs and memo files that have the .fpt file extension.
0
cymru_cowboyAuthor Commented:
Hi I've read through,
                Tried to do as it says but when I try and link using odbc in acces I'm getting the error "you cannot use ODBC to import from, export to, or link to an external Microsoft Jet or ISAM database table to your database." When I click on the help I get the message.
"You are attempting to link, import data from, or export data to either an external Microsoft Jet table or an external ISAM database table (for example, dBASE, Microsoft® FoxPro®, Paradox, or Btrieve), but you have selected <SQL Database> as the data source. You must select the appropriate data source for the data you are attempting to link." I'm missing where to change the datasource so its not <SQL Database>.

Cheers

0
CarlWarnerCommented:
Again, apply this as though it is dBASE and not FoxPro (I am a FoxPro person):

You cannot connect directly to FoxPro databases in Access 2003
http://support.microsoft.com/kb/824264/en-us
0
cymru_cowboyAuthor Commented:
Hi,
  Thanks for your continued help. The instructions in the last link seem to be the same as the previous links. I think I've followed the steps to the letter  (except dbase not foxpro) but I'm still getting the same error. It seems the crux of the problem is that somewhere along the line my datasource is set to <SQL Database>. Not sure how this is or where to change it. If you got any more time/suggestions I'd be grateful.

Cheers
0
CarlWarnerCommented:
It appeared to me that it wasn't locating the dBASE ODBC driver.  Make sure you actually have that installed.
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
cymru_cowboyAuthor Commented:
Hi there,
        I took a different tack in the end and found a program called abc amber dbf converter available here

http://www.processtext.com/abcdbf.html

This allowed me to convert the dbf to an excel file that actually pulled in all the memo fields from the dbt file. I then imported the excel file into access. Worked sweet as a nut and for only £12 cant be bad.

Cheers for your help anyway carl
0
CarlWarnerCommented:
They have great converters.

I got one that took old Clarion data and converted it to a dbf format.
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
Databases

From novice to tech pro — start learning today.