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)?