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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only