Hi,
This might not be a bad idea. I'll see if they can receive this data in the DELIMITED format.
Jacci
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement