>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?

This is a known error and has an MS KB doc. One resolution (besides the Excel95 format intermediary save) is to use the IMPORT FROM ... XL8 command...