hi,
thank you for reply,
main via vfp9 i can do it.
any way thanks.
best regards.
m.qasem
>>hi all,
>
>Hi Mohammed
>
>>i try to convert from mytable to excel sheet,
>>but he convert just 16363 records only ,mytable morethan 155700 records
>>i use to use this code under to convert,
>>how i can let him convert all records.
>>
>>USE moh55
>>gcDelimName = ALIAS( ) + '.xls'
>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>IF EMPTY(gcDelimFile)
>> CANCEL
>>ENDIF
>>COPY TO (gcDelimFile) XLS
>>
>>thanks ,
>>m.qasem
>
>From the excel 2003 helpfile:
>
>Feature Maximum limit
>Worksheet size 65,536 rows by 256 columns
>
>
>From the VFP 9 helpfile:
>
>Note:
>Though you can export a maximum of 65,535 rows, which includes one row
>reserved for the field header, versions of Excel earlier than 8.0 (Excel 97)
>display only the first 16,384 rows and cannot import files containing more
>than 32,767 rows.
>
>
>As you can see, it is not possible to export more than 64K of rows (read: records) to an excel worksheet. (Based on the latest versions of both VFP and Excel)
>So if you need to include more than 64K of rows, you either need to create multiple Excel files, or you need to create multiple worksheets in an Excel file (which COPY TO doesn't support, you need to use Automation)
>
>hth,