Re: DBF to Excel File, 16383 is the limit ?
- From: "Cindy Winegarden" <cindy_winegarden@xxxxxxx>
- Date: Sun, 30 Apr 2006 12:06:55 -0400
Hi Andy,
Something no one else has mentioned, XL5 is an especially old version of
Excel and can take a max of about 16K rows and you've seen. Later versions
of VFP have included XL8 in the Copy To options, which will give you about
64K rows.
Have you tried issuing _VFP.DataToClip(,,3) in the Command window and
pasting this into Excel?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
"andy" <andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:843BCC0F-7D9D-4E37-9B26-719540785DDE@xxxxxxxxxxxxxxxx
Dear All, I am using VFP6, I have DBF file with more about 30,000 records,
and I want to export them all to Excel file, I use copy to .... type xl5
command, and I only get at the most 16383 records. How to get all of the
records to the excel file without multiple cut and paste from different
excel
files? Thanks.
.
- Prev by Date: Re: corruption with vfp 8 - continued
- Previous by thread: Re: DBF to Excel File, 16383 is the limit ?
- Index(es):
Relevant Pages
|
