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