Hello. I wanted to ask, did anyone read the dat idx files? I know that they can be of different formats, but is there a normal solution and how to read them correctly? Ready to use any language, but preferably C #.

  • I'm afraid that dat files can be "absolutely with any content." But the almighty open opens any file (or is it called there in File Shape - FileStream?). These can be database files (even self-made) or SCADA CIMPLICITY. Therefore, to begin with, determine what you are going to parse. - KoVadim
  • KoVadim, but that's exactly what I'm doing now. Do not you know by chance that it was popular somewhere in the mid-90s? which engine? - semenvx27
  • For a start - dbase, foxpro. - KoVadim

1 answer 1

@ semenvx27 , IDX (as well as NDX) files are the index files of the legendary dBase . And DAT files are SQL tables of later dBase clones. In general, there were many sishnyh libs that worked with dBase clones.

What are you specifically interested in? If you simply receive data, it is easier to cling through ODBC - it’s hard to imagine that you need to parse the interior of these files ...

By dBase, I understand: own dBase itself, then Fox / FoxPlus, then Clipper and then Foxpro, at which the whole story ended.

Update

I was thinking here, the easiest thing is probably to raise Win95 on a virtual machine, run Foxpro on it and read the whole farm and then export it to another more modern format or at least to CSV. Foxpro as the last gasp of the dBase legend should understand all previous formats. Yes, and IDX is meaningless to read, these are index files, only DAT files are of interest to you.

  • Thanks, I will try. - semenvx27
  • @ semenvx27, read the response update. - Barmaley
  • @Barmaley ♦, tried to open use "... / file.dat", but FoxPro said Is Not a Table. I suspect that the previous versions will not work, because there is a suspicion of the CUSTOM format. Thanks for the answer, but you cannot say that the problem is easy to solve (if it can be solved at all). - semenvx27
  • Can you post the header of the DAT file in HEX (well, type the first 32 bytes)? - Barmaley
  • @Barmaley ♦ 1a ff 5d fe 34 00 b9 01 01 00 8c d8 00 00 00 00 00 00 a6 80 00 00 00 10 20 00 00 5c 88 00 00 c8 0f 01 00 18 9b 01 00 38 11 02 00 7c 5d 02 00 74 95 02 00 64 cc 02 00 - semenvx27