Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Unanswered: unknown .dat database

    i have a old database

    file structure example:

    DBNAME/DISCO1/DBNAME00.DAT, DBNAME01.DAT, DBNAME02.DAT...
    DBNAME/DISCO2/DBNAME00.DAT, DBNAME01.DAT, DBNAME02.DAT...

    ANOTHERDB/DISCO1/ANOTHERDB00.DAT, ANOTHERDB01.DAT.........
    ANOTHERDB/DISCO2/ANOTHERDB00.DAT, ANOTHERDB01.DAT.........

    each "DISCO**" folder is 408kb, except the last one in each database
    and contains 100 .dat files, each .dat file contains 100 records,
    and is without any comma separation etc, only "line separation"

    some of the folders include a file called "DISCNAME.DAT"
    which just contains the name of the folder and disk number.

    any idea what type of database this is? or how i can convert it to xls?

  2. #2
    Join Date
    Nov 2002
    Posts
    128
    Provided Answers: 1
    Unfortunately the .DAT file extension is too 'generic', all by itself, to mean anything specific.

    Generally it is merely some Text file that some application wrote out as a file.

    You can do a Google Search for DAT file extension and find where a wide variety of possibilities exist and that is merely some of the possibilities.

    Additionally the .DAT file extension is often used by some Backup utilities to write out data into a 'generic' text format.

    Therefore unless someone else recognizes the specific file naming convention you mention, I seriously doubt that these files combine to be any type of Database - maybe some backup of something, but not a Database itself.

    And, due to the 'generic' aspect of the file extension, I doubt that you will get a definitive labeling of the type.

    But perhaps you can 'extract' the data and use it in some manner.

    Since it seems as though you have already opened one or more of the files to examine their contents, maybe you could 'extract' the data by identifying the layout.
    You indicate that there are No Commas, but do the 'fields' appear to be in a standardized length format or have some other field separator - such as a Pipe ( | ) or Tab?

    Good Luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •