|
发表于 10-11-2011 04:22 PM
|
显示全部楼层
回复 40# blueyes
你可以用 sql select 来分段export 去excel. 由于vfp 属于32bit, 那export 去excel 时,maximum record 是 16383 + 1 (excel 1st row header)512 x 32
Eg.
select c.* from table1 as c where recno()< 16384 into cursor c_set1
**export the cursor
select c.* from table1 as c where recno()> 16383 into cursor c_bal_record
select c.* from c_bal_record as c where recno()< 16384 into cursor c_set2
**export the cursor |
|
|
|
|
|
|
|
发表于 7-12-2011 10:06 PM
|
显示全部楼层
回复 blueyes
你可以用 sql select 来分段export 去excel. 由于vfp 属于32bit, 那export 去exce ...
skyraven 发表于 10-11-2011 04:22 PM
use Excel XP can open 65535 records la,,,,
anyway, thx a lot, i settle it liao |
|
|
|
|
|
|
|
发表于 8-5-2012 12:31 PM
|
显示全部楼层
|
|
|
|
|
|
| |
本周最热论坛帖子
|