We help IT Professionals succeed at work.

Get data out of tables with odbc or oledb (IDX,FPT,CDX,DAT)

Uritsukidoji
Uritsukidoji asked
on
1,836 Views
Last Modified: 2008-01-09
Hi,

I have a directory with data, wich I assume is an old FoxPro data folder. I have no .DBF of CDF files, only .idx, .fpt, .cdx and .dat files

These files don't show up in the ODBC adminstrator panel when I use the FoxPro, DBase ODBC providers, or the Visual FoxPro OLEDB driver, nor opened when I select them using All files (*.*)

I need to retrieve the data in Visual Studio.NET. Does anyone know a procedure/driver to do this?

Thanks!
Comment
Watch Question

i dont think those files would be of any use to you if you dont have the .dbf files....

idx --- index file
fpt --- memo file
cdx --- compound index file

those 3 files were created from the dbf file...  and your ODBC driver is looking for the DBF file...
have you tried undeleting files from that same directory? or maybe they are just hidden files so try ATTRIB...

let me know...


Cyril JoudiehFounder, Software Engineer, Data Scientist

Commented:
Try opening the .dat and .cdf as dbf files in FoxPro first to see if they are originally DBF format. You can change the extention of these files and they will remain in DBF format and will use CDX, FPT and IDX.

USE mydatfile.dat

or rename the file's extention to a dbf and open it with ODBC.

Author

Commented:
Thanks, but I have no FoxPro at the moment. I'll try finding it somewhere if that's the only option.

I can confirm that I the .dat files do contain the actual data (35 mb) with partially readable data in notepad.

Renaming the .dat files to any foxpro like extension (dbf, dbc) doesn't work, I keep getting the error), Renamin9g them to dbf would only make them readable with the DBase (III?) driver right?
Founder, Software Engineer, Data Scientist
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I'll try. I've installed FoxPro, but renaming didn't enable me to open them as FoxPro files (both dbf and dbc). I'll try the free table mode now...

Author

Commented:
Excellent, renaming the .dat files to dbf worked... Thanks!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.