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 08:33:18
 
 
To
15/11/2002 06:07:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00721429
Message ID:
00723145
Views:
9
Sometimes, the C5 error can be caused by bad indices. If your combmail table has an index file, try deleting it and rebuilding the indices. I've also seen it cleaned up by deleting of the Foxuser.dbf and .fpt files.

Alan

>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
Reply
Map
View

Click here to load this message in the networking platform