Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from excel
Message
From
15/02/2008 06:58:06
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Import from excel
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01292874
Message ID:
01292912
Views:
31
You have 2 choices:

  • At another location specify 97-2003 format for Save instead of default. If it's Excel 2007 the format should be 5.0/95.

  • Use automation to re-save spreadsheet in desired format.

    >I am trying to import from an excel file into a cursor that i have created. I use the following
    >
    >mremitfile = GETFILE('xls',' ','OK',0,'Select the file')
>...
>APPEND FROM (mremitfile) TYPE XLS
>
    >and that works fine once the file is in 97-2003 format. the kicker is that i export this file from another location using OLE and it saves as an xls file, but if i try to import this file without saving as 97-2003 i get an error saying that the file type is not a valid xls. i would like to be able to import the file without getting the user to save as first
    >~M
    --sb--
    • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform