Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems importing spreadsheets
Message
 
À
22/02/2017 13:43:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
01648335
Message ID:
01648358
Vues:
39
>>My code is
>>
>>Set Default To j:\Global\ss
>>filex=Getfile()
>>
>>I then select my xls file
>>
>>code continues
>>
>>SELECT globalinx
>>append From &filex Type Xls
>>
>>I get an error message
>>
>>The instruction at "0x00028100" referenced memory at "0x000000000" the memory could not be written
>>
>>What is causing this and how do i resolve it?
>
>Are you sure the XLS file in question is indeed an XLS file and not something else (e.g. XLSX) that has been saved with an XLS extension?
>Are you able to open the XLS file in question in Excel? If so, how many rows and columns does it contain?
>
>IIRC a XLSX/DOCX file is essentially a PKZIP archive. If you open such a file in notepad, the first two characters will typically be "PK" (part of the "signature" that indicates a PKZIP file).

Thanks I will double check - but the file in question has loads of rows 50 or more which are not used
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform