Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cant seem to import xls file
Message
 
To
15/02/2017 06:22:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01647967
Message ID:
01647971
Views:
45
>>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


Colin
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform