Hi,

I’m trying to import data from Excel 97 files. I’m using the APPEND FROM
command to accomplish this:

*-- Add records from dlyblpss.xls
SELECT ImpBlpSs
ZAP && remove records from previous load
SET ORDER TO TAG stk_symbol

*-- Short Sales add records from DlyBlpMfSs.xls, but first have user get the
specific file needed
lcFile = GETFILE("XLS","DlyBlpSs.xls")
APPEND FROM (lcFile) TYPE XL8

Sometimes I get a C0000005 error on the APPEND statement and sometimes it
works. I seems to depend on the file. We are getting XLS files from
different sources and they are appended into their appropriate table
structures. We made sure that they were saved as Excel 97 files. The
really strange thing is that when this (dlyblpss.xls) file is saved as Excel
95 it works. Can anyone shed some light on this?

TIA,
Jacci