?
Solved

Delrina Perform to DBF and DBT and then into Access

Posted on 2006-03-30
10
Medium Priority
?
532 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:cymru_cowboy
  • 6
  • 4
10 Comments
 
LVL 33

Expert Comment

by:CarlWarner
ID: 16335219
How to use dBASE data with Access and Jet
http://support.microsoft.com/default.aspx?scid=kb;en-us;230125
0
 

Author Comment

by:cymru_cowboy
ID: 16340584
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
 
LVL 33

Expert Comment

by:CarlWarner
ID: 16344209
Sorry, I really gave you the wrong link, even info about Jet is just fine. :)
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 33

Expert Comment

by:CarlWarner
ID: 16344322
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
 

Author Comment

by:cymru_cowboy
ID: 16369247
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
 
LVL 33

Expert Comment

by:CarlWarner
ID: 16370054
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
 

Author Comment

by:cymru_cowboy
ID: 16370969
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
 
LVL 33

Accepted Solution

by:
CarlWarner earned 375 total points
ID: 16371301
It appeared to me that it wasn't locating the dBASE ODBC driver.  Make sure you actually have that installed.
0
 

Author Comment

by:cymru_cowboy
ID: 16399262
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
 
LVL 33

Expert Comment

by:CarlWarner
ID: 16400943
They have great converters.

I got one that took old Clarion data and converted it to a dbf format.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question