Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO *.xls TYPE XL5
Message
From
09/05/2003 22:50:43
 
 
To
09/05/2003 15:48:32
Vicente Jiménez
Heath Lambert México
Mexico City, Mexico
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00786926
Message ID:
00787002
Views:
17
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform