Import dat file content into ms sql server in a readable format

[bpremlatha]

Dat file generated by X application.This file in paradox database folder of this application. The main output data from the machine saved in this dat file. But, I could not read the content. Help me on how to read this dat file. A part of dat file content:

£<,?síÂ;ù÷™=�Âõ<wA?5)¼;M¡³=ìQ8=M@W?êMó;¡JÍ=�Âu=i´v?mUÐ;öóæ=¸…=   ±ƒƒ?áŠè;¥N >{®="”?§b<ù÷>=
×=!©?¥Ï<M¡3>®Gá=h�±?æØþ;¡JM>   >TG¾?¤
 <õóf>áz>M�Ó?C¬ <¥N€>
×#>’}ä?b‰þ;ù÷™>333>9Šõ?Ç6<£Ì¦>\�B>ãD@çã
<M¡³>…ëQ>¹ª    @õ<÷uÀ>=
W>Ëì
@¥ù<KÚ>fff>-S@ëí<õóæ>×£p>x¸@¸º<ŸÈó>Ház>¢û@§<ú¸?¸…>Æ'@Ol!<O#
?®‡>|Ã+@»<ù÷?…ë‘>Ùj6@r} <£Ì&?=
—>Ž®:@çø<<¢:
 

[Rabbit]

It's obviously a binary file and not a text file so there is no readable format of the base file. That's how the data is stored. You will need to contact gotech and see if they will tell you how they structure that binary file so you can interpret it.

[bpremlatha]

Thank you. How to identify whether the dat file content is binary? After get know how the data stored in dat file, must write some code to read the file? thank you.

[Rabbit]

You can tell because it's a jumble of characters. Once you find out from gotech how they structure the file, you will have to write code to read the structure.

[bpremlatha]

Thank you.Utf-8 are format for text type file. For the dat that have unreadable content but have textual data inside. If we convert to utf-8,then the file can be read? Thank you again. I will try to find out too.

[Rabbit]

Utf8 looks like ASCII unless it's characters for a different language.