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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only