Microsoft KB Archive/93688

{|
 * width="100%"|

ACC1x: Export Btrieve Table Without Existing Xtrieve FILE.DDF

 * }

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.