Message
From
15/02/2017 06:22:14
To
15/02/2017 05:59:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01647967
Message ID:
01647969
Views:
54
>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
>
>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