Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uploading an Excel 97 format file in Visual Foxpro 6.0
Message
From
15/11/2002 06:07:34
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00721429
Message ID:
00723111
Views:
8
Sergey,

When i even try to upload this Excel file from the command prompt in VFP6.0 using the command

append from filename.xls type xls

Fox responds with the message - Fatal error - Exception code C0000005

Also, when i use the .exe runs the error message is
Fatal Error - Exception code C0000005
Called from - form1.command1.click Line 10 {g:\almexe\upload.sct}
Called from - main line 12 {g:\almexe\main.prg}

Code associated with form1.command1.click
** asking the user for the input file and storing the name to a global variable
close tables
PUBLIC gctable
gctable = GETFILE('XLS', 'Browse:', 'Browse', 0, 'Browse')
THISFORM.text1.VALUE = gctable
**Calling the validation process to determine the field lengths
use combmail
zap
append from '&gctable' type xls
dele all for day = 0
pack
close tables
**If the user decides to conitnue enabling the upload option
THISFORM.command2.ENABLED=.T.
THISFORM.command2.SETFOCUS

P.S. - I can send u the screen dumps if u can give me your e-mail id. Basically, the issue here is that VFP 6.0 - append from command does not import the Excel 97 file format. Even copy to filename.xls type xls - does not export the output of the table to Excel 97.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform