Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Al exportar a XLS trunca las tablas

54 views
Skip to first unread message

Gustavo

unread,
Dec 8, 2001, 10:57:31 PM12/8/01
to
Hola a todos,

Tengo un problema al exportar tablas de Visual Fox a Excel
El problema consiste en que solo exporta las primeras 16384 filas.

Gracias de antemano.

Ing. Gustavo Guerrero Mendoza
San Luis Potosí
México

Alex Feldstein

unread,
Dec 9, 2001, 10:08:01 AM12/9/01
to
On 8 Dec 2001 19:57:31 -0800, obst...@starmedia.com (Gustavo) wrote:

>16384


El problema esta en el driver de VFP. Supongo que usaste COPY TO ...
TYPE XL5 (o XLS)

Lo que puedes hacer en este caso es copiar a una tabla en formato de
Foxpro 2.6 y abrirla desde Excel usando COM Automation.

USE MyTable && RECCOUNT("MyTable") > 16384
lcDBF = "c:\temp\MyDBF.dbf"
lcXLS = "c:\temp\MyXLS.xls"
COPY TO (lcDBF) TYPE FOX2X
loExcel = CREATEOBJECT("Excel.Application")
WITH loExcel.Application
.Workbooks.Open(lcDBF)
.ActiveWorkbook.SaveAs(lcXLS, -4143, "", "", .F., .F.)
.Workbooks.Close
ENDWITH
RELEASE loExcel


HTH
Alex Feldstein
Microsoft Visual FoxPro MVP
Please respond only to the newsgroups so that all may benefit.
For Fox related news using Web Services: http://foxcentral.net
My site is at: http://www.feldstein.net

0 new messages