[NEWBIE] Export Btrieve Files from Magic 7 App.

#1

Hi all,
I am looking for informations about Btrieve files to access datas

We have a software developping with magic 7 and there is no way to get an
access via odbc.

I proceed in two ways :

1) In order to get an access, I downloaded Pervasive SQL and copy each
btrieve file (*.dat) in the directory.
I create a new database and define each table.
Pervasive SQL recognizes automatically each field.
I can reach each table to MS ACCESS but there are some fields which don't
mean anything.
I try to define each table by using BTSearch but it returns also incorrect
datas

2) I export some data files to text by using BUTIL -SAVE but it returns the
same values !

Does anyone know how I could export files to access them by using ODBC (even
if it is not in real time) ?

Thanks for your help

Jerome DELGRANGE
jeromedelgrange (AT) yahoo (DOT) fr

#2

Jerome,

BtSearch will recognize all the btrieve data types as well as several
other data types. You can use BtSearch to help you analyze the
structure and build accurate DDf files. However, there are some data
types that ODBC will not recognize even if you have accurate DDF
files. However, BtSearch will export the data out to dbase or ascii
and then you could import the data into MS Access. If you have a data
type that BtSearch does not recognize then you need to find out what
type it is and perhaps it can be built in.

Gil

LHarvey <lharvey (AT) austin (DOT) rr.com> wrote

Quote:

I was under the impression that if you developed an application with
Magic that Magic could based on the information it had produce a SQL
schema for the data files it knows about.
May want to check along that route.

I know you are wanting ODBC, but you also state MS Access and not real
time. This brings up the possibility of just exporting the data via a
small magic app and importing from the file into Access.

The later statement does not add up.
If you developed the application you should know what all the data
types for all the columns are and the offsets for all the columns.

And no Pervasive SQL will only data type and field define the data it
knows about from the data file, and that is only the fields that fall
on idexes in the data files.

Butil -save does not do any data type conversions.
It is only unformatted with respect to the bytes stored in the record.
The "unformatted" file format is:
1) Ascii representation of integer field length
2) A comma ","
3) The bytes strored in the record - no data type translation is done
4) A newline.

If everything is stored as a string it is just as good as an export.
If some data is stored as say an integer, you just get the 4 bytes
that make up the integer, not a string representing the number.

Leonard

On Mon, 21 Jul 2003 08:57:56 +0200, "Jerome DELGRANGE"
jeromedelgrange_IHATESPAM_ (AT) yahoo (DOT) fr> wrote:

Hi all,
I am looking for informations about Btrieve files to access datas

We have a software developping with magic 7 and there is no way to get an
access via odbc.

I proceed in two ways :

1) In order to get an access, I downloaded Pervasive SQL and copy each
btrieve file (*.dat) in the directory.
I create a new database and define each table.
Pervasive SQL recognizes automatically each field.
I can reach each table to MS ACCESS but there are some fields which don't
mean anything.
I try to define each table by using BTSearch but it returns also incorrect
datas

2) I export some data files to text by using BUTIL -SAVE but it returns the
same values !

Does anyone know how I could export files to access them by using ODBC (even
if it is not in real time) ?

Thanks for your help

Jerome DELGRANGE
jeromedelgrange (AT) yahoo (DOT) fr

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[NEWBIE] Export Btrieve Files from Magic 7 App.

comp.databases.btrieve comp.databases.btrieve

[NEWBIE] Export Btrieve Files from Magic 7 App. - 07-21-2003 , 01:57 AM

Re: [NEWBIE] Export Btrieve Files from Magic 7 App. - 07-25-2003 , 12:43 PM