Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Truncation in XLS 3
Message
From
03/10/2006 05:25:56
 
 
To
02/10/2006 13:10:43
General information
Forum:
Windows
Category:
Computing in general
Miscellaneous
Thread ID:
01158607
Message ID:
01158796
Views:
31
>>Hi
>>
>>I import an HTML file into Excel. Fine - no truncation.
>>
>>However, the XLS needs to be processed by an old FPD2.6 system, so I save as an XLS 3, so the old system recognises it.
>>The data are then processed into a DBF.
>>
>>It's just been noticed that a fair slice of the data have been lopped off, to 16384 rows.
>>
>>I suspect thet Excel 3 has a max file size limitation, of c. 16K rows or something like that. Is this the case? I haven't a copy thereof to check.
>>
>>Secondly, any ideas on how to get round this? (I saved to Excel 3 as a precaution, as FPD2.6 won't recognise 97 as I have on board) How recent can I go with Excel versions?
>>
>>'ppreciate it.
>>
>>Terry
>
>Yes, it is limited. But you can append from the regular XL file in VFP and then use COPY TO to save it as a FPD 2X file.
>
>Regards,

Thanks Jim

Yes, that's all very well, and of course I knew that. But, there is an FPD program, part of an old system, that manipulates the xls and produces a FPD table (for further processing by the system). It's not just a case of saving it in Foxpro - that would be trivial.

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform