×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

An ASCII sequential file

An ASCII sequential file

An ASCII sequential file

(OP)
I need to export data from btrieve *.btr file. I used "butil -save file.btr file.asc" and I have got an ASCII sequential  file. How should I continue to export data into *.dbf format?

RE: An ASCII sequential file

I'm not sure about how to go from ascii to .dbf, but set up pervasive's ODBC drivers and set up link tables to your .btr files in MS Access.  Then write a simple query dumping everything into its own table and save it as a .dbf file.

If you have questions on how to do this let me know.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

RE: An ASCII sequential file

(OP)
I don't know the *.ddf files, so I think it would be difficult to use ODBC connecton, isn't it?

RE: An ASCII sequential file

usage  of *.ddf depends on the version of btrieve u r using. if u r using version 5.10 & below there is no *.ddf entries available.

in this case u need to know the file structure and create dbf file structure accordingly with provision for header i.e., 102,kasdkadasd  where 102, is the header in the dbf, in reality gives the length of the record in btrieve.  then give the command

use <mydbf file>
appe from <ascii saved file> sdf



icici

RE: An ASCII sequential file

(OP)
ouu, we are running btrieve 6.15... what now in this case?

RE: An ASCII sequential file

It is not difficult to use ODBC at all.  You should have ODBC as a part of btrieve,  Install it on your machine, and set up a DSN in control panel that points to your data.

Do you have crystal reports?  If so you can write a quick report in 10 minutes that will take every field in the table and export it to .dbf, or any number of formats.

Actually if you email me your data and .ddf files I can do it for you and email it back.  Contact me if you are interested.

dgilsdorf@altavista.com
714-348-0964

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

RE: An ASCII sequential file

(OP)
Thank you very much, but I have NO *.ddf files and I am not sure that I am able to create them.

RE: An ASCII sequential file

Get your ddf fies from the company that sold or developed the application.  I have had to do this before.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

RE: An ASCII sequential file

If you need to create DDF files for your existing Btrieve files check out BtSearch at www.nssdd.com. ; It helps you analyze your data and create the DDF Files.

Gil

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close