kako odpret DB datoteko (ni paradox)

zdravo,

mama en problem; delam en uvoz podatkov in podatke imam v *.DB formatu;

fora je v tem da te DB datoteke niso paradoxove (ker drugače bi jih brez problema uvozil v foxu z IMPORT FROM ? type PDOX)

ker mi pač javi napako "Paradox file format is invalid" sem pogledal v help kaj bi to lahko pomenilo; in sicer: "The Paradox file you have attempted to import is either not version 3.5 or has been corrupted."

aha, rečem mogoče pa te verzije DB zapisa fox ne podpira; pa si naloži dober star paradox in hočem odpret; ne gre!

potem si pa rečem, verjetno je to nek drugačen format; pa me zanima ali mogoče ve s katerim programom je moč uvozit/izvozit podatke iz DB datotek?

hvala za kak nasvet in lp

pa še tole sem našel

DB = ANSYS Database
DB = ArcView : Object Database File (also ODB)
DB = Borderland's Paradox 7 table database
DB = Configuration (dBASE IV - dBFast)
DB = data by dbVista
DB = data by Paradox
DB = data by Smartware
DB = data by Synopsys Design Compiler,
DB = data by XTreeGold
DB = MSWorks
DB = MultiEdit : Configuration
DB = Netscape Cache FAT.DB
DB = Progress Database
DB = Solid Database


ampak je tega preveč da bi vse probal; (teh DBjev imam za približno 600MB )

Pa Špiletič Milanu ste kot kaže dali posojilo za nakup stanovanja...

Saj zato ti pa pravim, da poskusi dobit računovodski program, ki je to datoteko uporabljal.
lp

Pozdravljen,

Na tvojem mestu bi datoteko .db odprl z nekim hex editerjom. V glavi imaš napisano v katerem formatu je shranjena datoteka. Pošiljam ti še prvih nekaj bitov, ki so napisani v hederju. Tako boš vsaj vedel kateri program za uvoz moraš izkati. Sicer pa če obvladaš Fox, poglej v helpu pod "Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx)".

Table Header Record Structure
Byte offset Description
0 File type:
0x02 FoxBASE
0x03 FoxBASE+/Dbase III plus, no memo
0x30 Visual FoxPro
0x31 Visual FoxPro, autoincrement enabled
0x43 dBASE IV SQL table files, no memo
0x63 dBASE IV SQL system files, no memo
0x83 FoxBASE+/dBASE III PLUS, with memo
0x8B dBASE IV with memo
0xCB dBASE IV SQL table files, with memo
0xF5 FoxPro 2.x (or earlier) with memo
0xFB FoxBASE

1 - 3 Last update (YYMMDD)
4 – 7 Number of records in file
8 – 9 Position of first data record
10 – 11 Length of one data record, including delete flag
12 – 27 Reserved
28 Table flags:
0x01 file has a structural .cdx
0x02 file has a Memo field
0x04 file is a database (.dbc)
This byte can contain the sum of any of the above values. For example, the value 0x03 indicates the table has a structural .cdx and a Memo field.
29 Code page mark
30 – 31 Reserved, contains 0x00
32 – n Field subrecords
The number of fields determines the number of field subrecords. One field subrecord exists for each field in the table.
n+1 Header record terminator (0x0D)
n+2 to n+264 A 263-byte range that contains the backlink, which is the relative path of an associated database (.dbc) file, information. If the first byte is 0x00, the file is not associated with a database. Therefore, database files always contain 0x00.

lp, Andrej