Message
From
15/02/2017 07:47:57
To
15/02/2017 07:35:51
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Miscellaneous
ID da thread:
01647967
ID da mensagem:
01647980
Views:
34
>>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.htm
>
>Also 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).
Thanks
>>
>>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.htm
>
>Also 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).
Thanks
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing
I run courses in Business Management and Marketing