#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual BASIC in Excel Emerogork via OfficeKB.com Excel Worksheet Functions 1 August 27th 07 07:06 PM
Visual BASIC in Excel Emerogork via OfficeKB.com Excel Worksheet Functions 1 August 27th 07 04:53 PM
changing the visual basic in office 2003 to visual studio net bigdaddy3 Excel Discussion (Misc queries) 1 September 13th 05 10:57 AM
Excel and Visual Basic \remy khalil via OfficeKB.com\ Excel Discussion (Misc queries) 1 July 7th 05 01:05 PM
visual basic in excel - DKehl Excel Discussion (Misc queries) 2 March 23rd 05 07:23 PM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"