Alpha Video Training
Results 1 to 10 of 10

Thread: cannot open FoxPro .dbf files

  1. #1
    Volunteer Moderator
    Real Name
    James A. Talbott, Jr.
    Join Date
    Apr 2000
    Location
    Lexington, KY
    Posts
    1,471

    Default cannot open FoxPro .dbf files

    I have a database of approximately 150 tables which was initially a FoxPro (Visual FoxPro ?) app that I would like to convert to Alpha.
    Most of the tables came across as if they are encrypted.
    Attached are two tables from this app. The table named ards.dbf came across fine, but the table named funcbehav.dbf did not come across fine.

    Can anyone make a suggestion how I can open these tables easily? I am not mainly after the data, mostly the structure.

    Thanks for looking.
    Jay Talbott

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: cannot open FoxPro .dbf files

    Behav func is encrypted and locked it shows

    I have no idea how to solve that one unless you can undo it with the tools that locked it and encrypted it


    .
    Dave Mason
    dave@aldausa.com
    Skype is dave.mason46

  3. #3
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: cannot open FoxPro .dbf files

    Hi Jay,

    I opened funcbehav.dbf in excel.

    It is still encrypted, but does not seem to have any data, just field names.

    Might give you a clue as to what is in there.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  4. #4
    Volunteer Moderator
    Real Name
    James A. Talbott, Jr.
    Join Date
    Apr 2000
    Location
    Lexington, KY
    Posts
    1,471

    Default Re: cannot open FoxPro .dbf files

    Keith,
    Thanks. Were you able to save it back as a dbf file and then open it in Alpha?
    I am not interested in the data, just want the structure of the table so I do not have to re-create the table.

    I do not have Excel, only Quattro Pro, and it seems to have an issue saving a dbf file. I'll have to try it on my daughter's laptop, which does have Excel.

    Thanks so much.
    Jay

  5. #5
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: cannot open FoxPro .dbf files

    Hi Jay,

    There is too much junk around the field names to get Alpha to import as a working table.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  6. #6
    Member Bob Houle's Avatar
    Real Name
    Bob Houle
    Join Date
    Apr 2000
    Location
    Vancouver Island, Canada
    Posts
    332

    Default Re: cannot open FoxPro .dbf files

    Jay,

    I opened these in DBF Viewer Pro from: http://www.legendsoft.com

    I PDF'd the structure for you to look at. There was only one record which consisted of only sample data.


    Regards,
    --Bob

  7. #7
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: cannot open FoxPro .dbf files

    Hi Bob,

    just want the structure of the table so I do not have to re-create the table
    Were you able to save the opened file for Jay?
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  8. #8
    Member Bob Houle's Avatar
    Real Name
    Bob Houle
    Join Date
    Apr 2000
    Location
    Vancouver Island, Canada
    Posts
    332

    Default Re: cannot open FoxPro .dbf files

    Took a little while.

    It seems as if there was a hidden (corrupt index?) problem that wouldn't allow Alpha to open the file.

    Looking closer I see that the offset to the first field is "2". Normally the offset should be "1" to allow room for the delete flag so the file may have been corrupt.


    Here it is.

    --Bob
    Last edited by Bob Houle; 07-30-2008 at 11:09 AM.

  9. #9
    Volunteer Moderator
    Real Name
    James A. Talbott, Jr.
    Join Date
    Apr 2000
    Location
    Lexington, KY
    Posts
    1,471

    Default Re: cannot open FoxPro .dbf files

    Thanks Bob and Keith.
    I finally got the files for the tables to convert to Alpha.
    I could not get the legendsoft demo product to open correctly, so I went with something from dbfdoctor.com
    Their product allowed me to save the file as a dBase IV format, so I was able to get what I wanted.
    Thanks again.
    Jay

  10. #10
    Member
    Real Name
    Jeff Fried
    Join Date
    Aug 2000
    Posts
    589

    Default Re: cannot open FoxPro .dbf files

    Jay,

    I don't know if you got your answer yet, but you need to convert the Visual Foxpro files down to the Foxpro 2.6 (A5) format. One way to do this is to open the file, then copy to another filename with the parameter fox2x. Then, of course, you will eventually need to rename that file back to its original name after moving the original somewhere else.

    Jeff

Similar Threads

  1. re: indexing when open dbf
    By jerry jones in forum Alpha Five Version 5
    Replies: 13
    Last Post: 06-04-2005, 10:38 AM
  2. Encrypting DBF files
    By kumargroup in forum Alpha Five Version 5
    Replies: 1
    Last Post: 10-23-2003, 11:02 AM
  3. a4v8 on win2k, delay to open dbf
    By Eddie Johansson in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 05-27-2003, 05:32 AM
  4. FoxPro 2.6 CDX files.
    By Dave LeYanna in forum Alpha Five Version 5
    Replies: 9
    Last Post: 08-20-2002, 05:15 AM
  5. Importing DBF Files
    By Michelle Nutting in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 05-18-2000, 06:15 AM

Bookmarks

Posting Permissions

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