Hi Ricardo,

if you keep on reading the old emails in the same thread I think you find

the answes (iirc one would be upgrade to Excel 2007)

Andrew Davies  MBCS CITP

  - AndyD        8-)#

Ricardo Aráoz

<ricaraoz@gmail.c To: profoxtech@leafe.com

om> cc:

Sent by: Subject: Re: Using Excel to handle VPF data

profoxtech-bounce

s@leafe.com

26/08/2007 13:42

Please respond to

profox

Andy Davies wrote:

> I do it the other way and use vfp to 'push' data to Excel

>

> If anyone's interested here is how I do it:

>

> My main form has a dataObj with properties for the database connection

and

> the name of a view or table of de-normalised data (I'm using a backend

> database but the same techniques would work for fox data).

> An option on the main form (menu, button, click event, w.h.y.) calls a

> modal form with a vfp field picker object on it, the user selects the

> fields they want and click a button to create a spreadsheet from the

data.

>

...

..

.

> IF RECCOUNT() > 0 THEN

> cFile = PUTFILE('What name?',ALIAS(),'XLS')

> COPY TO (cFile) TYPE XL5

>

(snipped)

I was rereading old mails of interest and I begun wondering.

The COPY TO ... TYPE XL5 will only copy about 16000 records (VFP6). Is

there a way to override this and copy more (or up to 64000)?

[excessive quoting removed by server]