At a client site we've had so many different spreadsheet formats with different versions of Excel or Lotus or whatever that we've settled on the Comma-separated Values format--any spreadsheet can read or write the format, and any version of FoxPro can load it as TYPE DELIMITED.


>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