Any help will be greatly appreciated.
Thanks,
Cris
CrisGC@<nospace>aol.com
If you spam me, you pay $500.
CrisGC wrote in message <199805081632...@ladder03.news.aol.com>...
>I am new to using Btrieve files. Can anyone tell me if there is a utility
to
>dump btrieve file records into a regular flat file and vice versa.
>
>Any help will be greatly appreciated.
There used to be a DOS program called BTFiler, that did this kind of
thing, you had to tell it though the file layout. And another DOS program,
bedit could do this, not sure where you could get either now...
> is there a utility to
> dump btrieve file records into a regular flat file and vice versa.
What do you mean by "a regular flat file"? The DOS program BUTIL.EXE,
as supplied with various BTRIEVE packages, will dump records into a
sequential file. As far as I remember each BTRIEVE record will
generate an entry in the file comprising the: record length in ASCII;
followed by a comma; the BTRIEVE data record, exactly as stored; and
a CR LF.
I don't know how variable length records are handled.
See BUTIL documentation. Option -SAVE will copy from a BTRIEVE file
to a sequential file; option -LOAD will copy from such a sequential
file to a BTRIEVE file.
Best wishes,
--
Michael Salem
Btrieve's utility BUTIL.EXE may do the trick. It will dump the raw
data into a flat file. The only trick is if numbers are stored in a
binary format, that format will be retained in the flat file instead
of showing the numbers as text.
From DOS, you need to have Btrieve running, and then the
syntax is:
butil -recover sourcefile destinationfile
On each record, the system will have the number of bytes in the record
followed by a comma, the record itself, and then carrige return, line
feed.
http://ourworld.compuserve.com/homepages/access_microsystems
or
http://www.webspan.net/~dreilly/
You need to either dump the record images (it will create a file in BUTIL
format, that is the length in Ascii, followed by a comma, followed by the
exact bytes saved in the file (binary data and all) or you can create an
ASCII description file (giving field lengths, types, start positions, etc)
and get a delimited file. If you have DDF files (I suspect you do not) you
can use our BTVIEWER to more easily get to delimited or dBase files.
CrisGC wrote in message <199805081632...@ladder03.news.aol.com>...
>I am new to using Btrieve files. Can anyone tell me if there is a utility
to
>dump btrieve file records into a regular flat file and vice versa.
>
>Any help will be greatly appreciated.
>
You might check out BtSearch. It allows you to send your data to ascii or
dbase format. It is a Windows program where you select the file and then any
or all fields to export. If you don't have the DDF files (file.ddf,
field.ddf) then it also will help you in creating these files.
Gil
In article <199805081632...@ladder03.news.aol.com>,
cri...@aol.com (CrisGC) wrote:
>
> I am new to using Btrieve files. Can anyone tell me if there is a utility to
> dump btrieve file records into a regular flat file and vice versa.
>
> Any help will be greatly appreciated.
>
> Thanks,
> Cris
> CrisGC@<nospace>aol.com
> If you spam me, you pay $500.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading