Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and 16383 records
Message
 
 
To
27/08/1999 10:52:04
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00258393
Message ID:
00258441
Views:
12
>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...
Kevin Scott
kehvn@carolina.rr.com


Hey! It's not my fault. It's some General named Protection!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform