ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   visual fox X excel (https://www.excelbanter.com/excel-discussion-misc-queries/164954-visual-fox-x-excel.html)

Neia

visual fox X excel
 
I have created a dbf file using Visual Fox and it has 36257 records.
Now I need to copy this to a excel format file(xls) but I had a problem
because only 16383 records have been copied.
I used the following command into VFP: COPY TO file.xls TYPE xl5.
When I copy to a dbf file all the records are recorded and if I open excel
with .dbf format I see all them.
What Can I do?

Jim Cone

visual fox X excel
 

No experience with Visual Fox (whatever that is), however you are specifying
a file type of xl5 and XL5 only had ~16000 rows.
You will probably have to specify a file type of xl8 or higher.
The later versions have ~65000 rows.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Neia"
wrote in message
I have created a dbf file using Visual Fox and it has 36257 records.
Now I need to copy this to a excel format file(xls) but I had a problem
because only 16383 records have been copied.
I used the following command into VFP: COPY TO file.xls TYPE xl5.
When I copy to a dbf file all the records are recorded and if I open excel
with .dbf format I see all them.
What Can I do?


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com