General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>My code is
>>>
>>>CLEAR
>>>CLEAR ALL
>>>USE c:\global\globalin IN 0 EXCLUSIVE
>>>SELECT globalin
>>>ZAP
>>>append FROM j:\global\ss\aaa.xls TYPE xls
>>>
>>>Microsoft Excel file format is invalid
>>>
>>>
>>>
>>>What am I doing wrong?
>>
>>Aside from Martina's suggestion that it's actually an XLSX, also try type XL5.
>>
>>Tamar
>
>
>Can I upload the file for you to see - I have tried type xl5 - makes no difference
I saw that you said it is XLS. By any chance, did you create it by saving it from a newer version of Excel (2007 or later). The XLS files created there are different than the ones created by earlier versions and VFP can't import them. I consider it a bug in Excel, but Microsoft has no intention of fixing it.
Tamar
Previous
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