ACC1x: Export Btrieve Table Without Existing Xtrieve FILE.DDF

 Last reviewed: April 2, 1997
Article ID: Q93688
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1

SUMMARY

To export a Btrieve table by using the Microsoft Access user interface, you must ensure that an Xtrieve dictionary file (FILE.DDF) exists. If the FILE.DDF file does not exist, use the macro action Transfer Database to export the table.

MORE INFORMATION

Multiple Btrieve tables can exist in Xtrieve databases, just as Microsoft Access databases can have multiple tables. The FILE.DDF file describes the structure of the Xtrieve database.

Example

The following sample macro (TransBtrieve) transfers the Customers table from the sample database NWIND.MDB to a Btrieve Table named Customers in an Xtrieve database named C:\ACCESS\BTV00000.DAT. If C:\ACCESS is a valid directory, the export occurs even if BTV00000.DAT does not exist.

Use the following as a guide to create the sample macro. Note that the database name can be any complete file specification. 

   Macro Name      Action
   --------------------------------
   TransBtrieve    TransferDatabase

   TransferDatabase Action
   -----------------------------------------
       Transfer Type: Export
       Database Type: Btrieve
       Database Name: C:\ACCESS\BTV00000.DAT
         Object Type: Table
              Source: Customers
         Destination: Customers
      Structure Only: No
NOTE: You must have the file WBTRCALL.DLL in the \WINDOWS\SYSTEM subdirectory. If you have Microsoft Access installed locally, this file should be about 51K. If you're running Microsoft Access off a network, then this file will be about 13K.

Microsoft Access creates the following four files if they do not exist: 

   FILE.DDF
   INDEX.DDF
   FIELD.DDF
   BTV00000.DAT
Transferring more than one table adds data to the existing files, but does not create more files as long as the database name is not changed.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 4, "Importing, Exporting, and Attaching," page 86

Keywords : IsmBtrv kb3rdparty
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.