Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Question Unanswered: Exporting from Foxbase / pro / plus

    Is this possible, it looks like it was from the dark ages!
    any help would be great! would really like to get the data into excel!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I beleive you want something along the lines of
    Code:
    USE MyTable
    COPY TO MyWorkbook TYPE XL5
    *--+ OR
    USE mydbf IN 0
    EXPORT TO c:\MyWorkbook.xls TYPE XL5
    Hope this helps
    ~George

    EDIT: This is using the Command Window
    There are other methods but this would probably be easiest - let us know how you get on please!
    Last edited by gvee; 07-16-07 at 09:37.
    George
    Home | Blog

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Have you tried Microsoft Query?

    Sam

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Try opening the files from within Excel. In the file browse form, look at the file type. Foxpro files are based on dbase, so you might be able to use that option.

    If you don't have the odbc drivers/oledb providers installed, re-install Excel; you have the option of adding additional drivers/providers in the custom install.

    Now, depending upon your MS Office version (Office 2002 or greater,) you may need to use the FoxPro ODBC driver. Ref this MS KnowlegeBase article. (although this link is specific to Access, it should also work for Excel) I would recomend that create a file dsn using the FoxPro ODBC driver, and store it in an easily accessible location.

    Then, from Excel, one of the file open dialog file type options is for "All Data Sources," which includes DSN files.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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