I have been banging my head on this for a few weeks now and thought I would start asking around. I have an unidentified database structure that I would like to be able to convert back and forth between a csv or excel file.
In excel the format would look like this:
0 1 4
433 31 40
434 51 46
Any help in identifying or pointing me in the right direction of a conversion program would be very very helpful.
Print a portion (at least the first few records, and the last) of the unknown database in hexadecimal (use debug) and then patiently determine which characters are data, and which are field/record separators.
Some features that may make your life difficult:
the data is compressed; "0000000000" is stored as 10x0
the numeric fields are stored as binary
the data is encrypted
the data is encoded; 0=black, 1=yellow, 2=red, 8=white
the data is stored as ordered pairs; cell1=25, cell4=30 (cell 2 and 3 are presumed zero or null)
The first block of data in the file may also be the structure, not the data, also if there are indexes, these may also be part of the file.
There may also be a label record; may contain copyright info, date/time last change, number of records etc.
If you can, create an empty file and see what is stored, then add 1 record and dump the file to hex again.