Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COPY TO *.xls TYPE XL5
Message
De
09/05/2003 22:50:43
 
 
À
09/05/2003 15:48:32
Vicente Jiménez
Heath Lambert México
Mexico City, Mexique
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00786926
Message ID:
00787002
Vues:
16
>how can i make for export more than default records?

The problem is not in VFP but in the driver.

See:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q103355

What you can do is copy to a Foxpro 2.table and open i from Excel using 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


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform