INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Dbf extensions file

Dbf extensions file

(OP)
Hey guys, hoping someone can help me out here.

How to open .dbf extensions files? I have tried FoxPro but no luck.

Thanks in advance

RE: Dbf extensions file

Do you have a copy of Foxpro or Visual Foxpro installed on your computer?

If so, follow these steps:

1. Go to the command window. If you don't know how to do that, just press F2.

2. In the command window, type USE xyz (and press Enter), where xyz is the name of the DBF file, including its path.

3. If you see an error message, check the spelling of the filename and pathname, and also that the file exists in the specified path.

4. If there is no error message, type BROWSE (and press Enter). You should now see all the data in the file.

5. If it still doesn't work, come back here.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Dbf extensions file

Which version of FoxPro do you have?

RE: Dbf extensions file

Quote:

Which version of FoxPro do you have?

I think the solution I gave will work with all versions of FoxPro, all the way back to 1.0.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Dbf extensions file

No, not necessarily. If someone has an old FoxPro version and tries to open a table created with a newer version, it won't work if some of the newer field types are used.

Also other programs can create dbf tables which aren't compatible with VFP, for instance xBase++.

RE: Dbf extensions file

Yes, Mikes point 5 would care for that.

In first degree Mikes advice is very sound and good when you don't know how to handle Foxpro. The DBF file extension will typically be associated with the VFP IDE unless some tool installed later overruled that.

If it is VFP associated double clicking normally should get you right into the BROWSE window within a new VFP IDE session - it does in my VFP9 installation - but your mileage can vary, eg installing some reg keys from a Berezniker blog article makes VFP open a DBF in a currently running IDE session and obviously having Alaska or dBase or xHarbour or anything else installed after VFP can change the rules.

So opening a DBF file from within the IDE might lead to more insights also via error messages. Indeed "Not a table" can point out it has unknown features of a later version DBF, you don't get that in VFP9, though, unless the second reason applies and the DBF is corrupt or not a VFP DBF. Byte 0 of the file holds file type info, so some variants may just be known from reading the first byte of the DBF file. See https://msdn.microsoft.com/en-us/library/aa975386(v=vs.71).aspx

Other systems might add values not documented here or even mark a DBF as whatever specific type at other header bytes, so don't think this is a complete and comprehensive list. It is just the VFP point of view on DBF types.

Bye, Olaf.

RE: Dbf extensions file

Nobody spotted my mistake in step 1 of my post. To open the command window, press Ctrl+F2, not plain F2. (Just keeping you on your toes.)

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Dbf extensions file

I am not qualified to say which DBF types the tools you mention cover. I doubt dBase will open all types of VFP DBF. Maybe the latest version was changed to enable that. VFP itself can only open some legacy dBase file types, the types, which were current at the time Foxpro was meant as competition to dBase.

Excel can only open legacy dbfs and can harm current VFP dbfs, I wouldn't recommend that, the same goes for Access. I won't troll against Open Office without knowing more, I never did use that, but I doubt any *nix system product handles all DBF types correctly. In the end there is no tool covering all DBF types, also VFP does not.

Bye, Olaf.

RE: Dbf extensions file

I use a program named VRUNFOX when I can't install my development VFP on a client site. It is a little bit cumbersome but gives you the FoxPro command window. Once installed use Mikes instructions to browse the tables. Search net for VRUNFOX.

John

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close