>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?
Hi Colin,
VFP is only capable of appending/importing rather old formats (xl5 and earlier). That practically means you cannot use append from or import with Excel files. Instead you can directly connect to excel via OLEDB or ODBC and get your data. Check this for detailed explanations and code(s) to do that:
https://www.foxite.com/archives/0000153776.htmAlso a note: Do NOT rename an XLSX with an XLS extension. If you do that even Excel itself is confused about the format of file (XLSX is a compressed XML format while XLS was binary).