ACC1x: Export Btrieve Table Without Existing Xtrieve FILE.DDF

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 : kb3rdparty IsmBtrv
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbinfo