Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and 16383 records
Message
From
27/08/1999 12:44:56
 
 
To
27/08/1999 11:22:07
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00258393
Message ID:
00258495
Views:
10
I just meant whoever is using Excel to look at the 45,000 records may not be using the right tool. Anyway, since your a Fox guy, I probably didn't need to mention it in the first place anyway <g>.

>>Hi Kevin,
>>I just got that number(65 k+) out of the help file.
>
>Yeah, it appears that saving a file as a XLS only allows for 16k.
>
>>First, sorry but I just have to say this, but it sounds like your having to use the wrong tool for the job. Anyway...
>
>Hmm. Not saying that I've never used a butter knife as a screwdriver but since the file is already created from VFP and OLE pops up Excel with the file open, it is extremely fast. I may be wrong but to use DataToCLip method seems like an extra step, and a fairly BIG one. IOW, I have to create the table anyway. As an example let's say that I do a query that results in a table with 45,000 records. Now if I can just open that file in Excel then that would be great! But it would require an extra step to copy that file and paste in excel.
>
>I've seen other systems that do the copy/paste thing and I can usually go get a cup of coffee and come back before it is done. In all fairness though, I have never done it that way in my system. But to break up my file into 3 files and open 3 worksheets may not be any faster...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform