General discussion

  • Creator
    Topic
  • #2094048

    Btrieve conversion

    Locked

    by thump ·

    I am trying to convert from a Btrieve database into a CSV or Access type data base. Has anyone done this?

All Comments

  • Author
    Replies
    • #3849368

      Btrieve conversion

      by thump ·

      In reply to Btrieve conversion

      If so, how??? Thanks

    • #3849352

      Btrieve conversion

      by zalog ·

      In reply to Btrieve conversion

      You can use the BUTIL.EXE utility to save the records to a sequetial file. Use the command BUTIL -SAVE btrievefile outputfile. This may not work if your files contains packed numeric fields. If that is the case you will to write a program with the specific file layout which can be determined using the BUTIL -STAT btrievefile command.

      • #3849311

        Btrieve conversion

        by thump ·

        In reply to Btrieve conversion

        All I have is the data files. Where do I get this tool?

    • #3850106

      Btrieve conversion

      by emcs ·

      In reply to Btrieve conversion

      Go to MicroSoft’ Knowledge base Search at: http://search.support.microsoft.com/kb/c.asp?ln=en-us, and look at article Q119472 – ACC: How to Use an Import/Export Specification in Another Database. It is a step by step walk through of how to import data. If you can export from Btrieve in a .txt file or another database file, there will be little problem in importing into Access.

      It can and has been done.

      Good luck.

      dennie

      • #3840529

        Btrieve conversion

        by thump ·

        In reply to Btrieve conversion

        The problem is getting it out of he Btrieve format. Any thoughts?

    • #3884748

      Btrieve conversion

      by mtnsqs ·

      In reply to Btrieve conversion

      I Think Crystal Reports will retrieve from a Btreive DB – and Crsytal can convert the data adn save it in a CSV or similar format – then you would be able to get it back into your other DB.

      Trouble is Crystal is expensive to buy – you may need tofind someopne close to you who has a copy to use to do it.

      • #3643605

        Btrieve conversion

        by thump ·

        In reply to Btrieve conversion

        The question was auto-closed by TechRepublic

    • #3661525

      Btrieve conversion

      by dad1964 ·

      In reply to Btrieve conversion

      Crystal Reports will work, if you can afford it, and if you have the correct ODBC “driver of the week”… MSAccess will work with the correct ODBC driver. I’ve used both and Access worked better – but that was almost 5 years ago. Maybe the drivers have gotten better since then.

      • #3643606

        Btrieve conversion

        by thump ·

        In reply to Btrieve conversion

        The question was auto-closed by TechRepublic

    • #3643604

      Btrieve conversion

      by thump ·

      In reply to Btrieve conversion

      This question was auto closed due to inactivity

Viewing 5 reply threads