How to Read .dat and .idx Files

May 27th, 2011,08:43 AM

Howdy Guys,

We are in the process of upgrading a clients software. I'm not certain what database their existing app uses but in the db folder there are DAT and IDX files.

I need to find a manner of reading those files then I can import the data across to the new database. Can someone delight advise me on how I tin go most this task. Thanks

May 27th, 2011,08:59 AM

You lot can't really tell what the db is based on a file extension.

I could be using SQL Server the standard is mdf for the extension (also employ ndf and ldf) but I can use pdf, sdf , zzz, dat as the extension it actually means zip.

May 27th, 2011,09:36 AM

assuming they are default extenstions, they are dBase 4 files... the .DAT ones are the actual information files (or tables) and the IDX files are the indexes... put them all in a binder... when you make a connectedness to them, connect to the Folder... so the names of the DAT files get the table names.
in other words: Folder = DatabaseName; DAT Files = Table Name

-tg

May 27th, 2011,eleven:45 AM

Establish in the internet

dBase:
A major legacy of dBase is its .dbf file format, which has been adopted in a number of other applications.
dBase uses .ndx files for unmarried indexes, and .mdx (multiple-index) files for holding between 1 and 48 indexes. Some xBase languages include compatibility with .ndx files while others use dissimilar file formats such equally .ntx used by Clipper and .idx/.cdx used by FoxPro or FlagShip. After iterations of Clipper included drivers for .ndx, .mdx, .idx and .cdx indexes.

.DAT
Generic data file created by a specific application; typically accessed but by the application that created the file; may incorporate data in text or binary format; text-based DAT files can be viewed in a text editor.

Many programs create, open, or reference DAT files, including:
Microsoft Visual Studio
Corel WordPerfect
Nero ShowTime
Nullsoft Winamp
SoftVelocity Clarion
Ontrack EasyRecovery
Runtime GetDataBack
Pitney Bowes MapInfo

.IDX
Stores an index of files used by various programs; used past search functions to speed up searches; in one case a hard deejay, directory of files, or database is indexed, the data tin be searched and sorted more than efficiently.

JG

May 30th, 2011,08:48 AM

Hi Guys,

wow yous guys really know your stuff. Techgnome I want to go with your advice. When you say connect, how do y'all mean? I adopt working with these in vb.cyberspace if possible. Can y'all show me how I tin achieve this please

May 30th, 2011,09:07 AM

i tried creating a dsn in my odbc datatsource manager. I notice if I create a dbase i it looks for *.dbf;*.ndx;*.mdx files only. Will I be able to read the DAT files still?

May 30th, 2011,09:37 AM

Maybe the old application (the one you desire to upgrade) has an Export option, to text, to excel or impress to disk, etc... and from that output Y'all could practise a routine of data conversion

JG

May 31st, 2011,04:06 PM

Get a hex editor and open upward the file in it. Commonly the header information of the file will tell you what kind of file it is.

Jun 1st, 2011,01:09 AM

hi abhijit,

thank you for that. unfortunately I just get abunch of 1's and 0's. nothing conclusive that i tin can work with

Jun 1st, 2011,06:33 AM

May Yous post/attach a smal .DAT file?

JG

Jun 1st, 2011,08:05 AM

Quote Originally Posted by Nitesh View Post

hi abhijit,

thanks for that. unfortunately I simply get abunch of 1'south and 0's. nothing conclusive that i can work with

Quote Originally Posted by jggtz View Post

May Y'all postal service/adhere a smal .DAT file?

JG

Seconded! Please post a .DAT file. If you find it easy, use dropbox to share the file.

Jun 1st, 2011,08:xvi AM

sure. I've attached both a DAT and IDX File.

Jun 1st, 2011,08:24 AM

Quote Originally Posted past Nitesh View Post

sure. I've attached both a DAT and IDX File.

The IDX file appears to have a signature of DBASE or FoxPro system. The DAT file is however an unknown quantity at this bespeak.

Jun 1st, 2011,08:25 AM

Quote Originally Posted by Nitesh View Post

hi abhijit,

thanks for that. unfortunately I just get abunch of ane's and 0's. nothing conclusive that i tin work with

Also if you are ever in doubt about a file, you might want to cheque out this utility

Jun 2nd, 2011,04:54 AM

wow, you are practiced. I think it is a DBASE database. The technician I spoke to said he vaguely remembers something nearly DBASE. IS there any fashion I can go the data of the DAT files? thanks again abhijit.

Jun 2nd, 2011,06:52 AM

try changing the extension to dbf and run across if that helps....if it doesn't, try putting it dorsum to DAT and see if that does annihilation... or merely try to connect to the DAT start, then change the extension if information technology doesn't work... what ever, effort 1, then the other.

when building the connexion cord, the database "name" is the path to the folder where the dbf file is... the table name is then the name of the dbf itself (w/o the extension).

-tg

Jun 3rd, 2011,06:26 AM

How-do-you-do Tg,

I tried your suggestions but renaming the files hasn't worked

Jun 3rd, 2011,06:44 AM

bleh... I'm out of ideas... and you don't know what kind of database was being used by the system before?

-tg

Jun tertiary, 2011,06:57 AM

no prob. Cheers for trying though. Unfortunately I have no idea what the database was

Jun 3rd, 2011,07:12 AM

What about the source code of the original app.... is it possible that the connection string (or what ever was used to connect to information technology) could exist in there?

-tg

Jun 29th, 2011,03:17 PM

Help you lot with what? If you lot have a question, post it in the appropriate forum section. If someone tin then assist yous, they will.

-tg

Jun 29th, 2011,03:39 PM

Quote Originally Posted past helpme2 View Post

techgnome, can i talk with you at msn-skype or yahoo ,

No...

Quote Originally Posted by helpme2 View Post

i recollect you may have answer to my question and after we get solution i 'll blazon it in suitable thread

Ummm... no, that'southward not how it works... you need to find the advisable forum section for your question... given the question below, information technology probably belongs in the graphics department... you post the question and someone volition and so answer... either with an respond or more than questions to aid solve the trouble. That's the fashion forums piece of work.

Quote Originally Posted by helpme2 View Post

can't i even message yous here in your personal page

I know that... I've had to plough information technology all off because of instances like this... I fifty-fifty say so in my signature... PM'southward are not condusive to the learning procedure...

Quote Originally Posted by helpme2 View Post

i have aquestion realted to how to read blackness pixel positions(x,y) of the bitamp picture
i.e. check sure (10,y) pixel if blackness or non
past vb forum

In that location... was that then hard... now copy what you wrote... go find the graphics section, and post a new thread in there with that every bit the question. I'll even tell you what to utilize for the subject field line: "Need assistance getting pixel colour" ... don't forget to also mention what version of VB you are using. It'll make a difference in the reply you become.

-tg

Jul 20th, 2011,01:33 AM

Hullo Guys,

I got back to this yesterday and after googling for two hours I found something. My friend suggested I use vb6 for this chore. Then I googled "DAT Files vb6" I eventually institute a forum suggesting it could be DBASE, FoxPro or DBISAM. Since I previously tried the first two I decided to google DBISAM.

I downloaded software called DBISAM Viewer. Tried it out and I was able to read the dat files. I gives me the tabular array structure, the data in each table every bit well every bit enables me to do a sql dump of the data. Information technology aint costless though. Cost me xx Euros but it's worth information technology considering all the time I spent on this previously. Now I tin can start importing the data across to the new database. thank you again everyone for your contributions

Jul 20th, 2011,06:39 AM

hey hey! SCORE! Certainly sounds like information technology was 20Euros well spent! Small price to pay if you lot ask me.

-tg

Jul 20th, 2011,09:46 AM

Quote Originally Posted by Nitesh View Post

Hi Guys,

I got dorsum to this yesterday and after googling for two hours I found something. My friend suggested I apply vb6 for this chore. So I googled "DAT Files vb6" I eventually plant a forum suggesting information technology could be DBASE, FoxPro or DBISAM. Since I previously tried the first two I decided to google DBISAM.

I downloaded software called DBISAM Viewer. Tried it out and I was able to read the dat files. I gives me the table structure, the information in each table besides as enables me to do a sql dump of the data. It aint free though. Cost me 20 Euros but it's worth it considering all the time I spent on this previously. Now I can start importing the data across to the new database. thanks again everyone for your contributions

Cool. DBISAM viewer seems like the way to go. How does it handle large files?

Jul 21st, 2011,01:23 AM

hey abhijit,

I will be getting the licence today so I tin test large files. At the moment I tin can simply read the 1st 100 records of each table with the trial version. I will post back as soon as I have some news

Apr 4th, 2013,02:nineteen PM

Hi
i accept too a DBISAM dat and idx file, what i cannot read. Can i enquire about your dbisam viewer? I have only the limitationed version.

Thanks your assist

How to Read .dat and .idx Files

[RESOLVED] How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: How to Read DAT Files

Re: [RESOLVED] How to Read DAT Files

Re: How to Read DAT Files

Re: [RESOLVED] How to Read DAT Files

Re: [RESOLVED] How to Read DAT Files

Posting Permissions

0 Response to "How to Read .dat and .idx Files"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel