Re: import or link to VersaSoft dBMAN

[Eric Nichols]

These "propriatary" files were from a custom xbase Versa Soft dBman application.


A note from the author:


To export to a standard .DBF file, go to the Command Line Interface



At the “CMD:” prompt, type the following commands:



SET DB3 ON (this sets Canefire to create files in standard .dbf format)



USE STOCK (or any other CaneFire .dbf file)



COPY ALL TO {drive:\folder\filename)



Example: COPY ALL TO C:\EXPORT\STK

This will create a file with a .DBF extension if one is not specified

This will create the file STK.DBF in the C:\EXPORT folder. C:\EXPORT must exist beforehand.

You should always specify a folder name. Not doing so will create the specified file name in the default data folder, and if you specify a filename that already exist, you will overwrite it.

Also, use only dos 8.3 file names.





To export to comma delimited files, SET DB3 ON is not necessary, and use the following syntax:



COPY DELIMITED TO {drive:\folder\filename)

This will create a file with a .TXT extension if one is not specified
I hope this will help other customers in their transition from dbman applications.