Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting from VFP to Excel

Status
Not open for further replies.
aiden

aiden

Programmer
Apr 23, 2001
27
CA
HI

When exporting data from VFP6.0 to Excel format(XL5), I am limited to about 16,600 rows. Can someone tell me if VFP 7 can export more rows, and if so, how many?

Thanks.
 
Sort by date Sort by votes
One way around the limitation: export to csv file. The user then opens the csv file -- can save in it excel format. CSV's do not have the size restriction in VFP.
 
Upvote 0 Downvote
Quoting the VFP help file "XL5 ... Creates a Microsoft Excel version 5.0 worksheet file. ...". Excel version 5.0 had a limit of 16,384 rows. I believe version 7.0 (Excel 95) was the first to allow 64k rows, and no version of VFP (yet) supports this file type.

You can COPY TO ... TYPE FOX2X or TYPE DELIMITED - all 32-bit versions of Excel can import these. You could also use Automation to directly load a spreadsheet if you know each workstation has Excel installed.

Rick

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
MySql to VFP cursor
Replies
11
Views
809
Chriss Miller
C
dylim
  • Question
Correct Connection String VFP to MariaDB
2 3
Replies
56
Views
2K
dylim
dylim
F
  • Question
Mapping touch gestures to legacy VFP apps
Replies
1
Views
263
fire555
F
dylim
  • Question
Latest VFP Version
Replies
15
Views
783
Chriss Miller
C
C
  • Locked
  • Question
SQLEXEC crashes VFP 1
Replies
9
Views
636
Claudio Costa
C

Part and Inventory Search

Sponsor

Back
Top