I've the all too familiar error:
Exception code=C0000005
Called from - form1.cmdimport.click line 5
{c:\mydir\forms\myform.sct}
Here is what my command button click code looks like on my form:
LOCAL lcFileName
USE \mydir\data\temptabl IN 0 SHARED
SELECT temptabl
lcFileName = ALLT(THISFORM.txtFileName.Value)
APPEND FROM &lcFileName XL8
I get the error on the APPEND FROM line and that throws me out of VFP running of the form. I have a filename for an EXCEL spreadsheet which is displayed on the form after I do the "Open File" command button on my form just before I press this "Import File" button. The error happens on the "Import File" button. All I am trying to do is take an Excel spreadsheet and append it to a table that has prestructured fields that will contain all of the spreadsheets columns. Or is my table that I am appending to setup wrong? Usually I can work around this error, but not this time.
Any ideas? Thanks for the help.
Steve Kramer
Kramer & Kramer Design
http://members.aol.com/gocartoonsgocartoons@aol.com
Home of over 260 original, off-the-wall cartoons by your truly.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.