Client Application is in VFP9, database MS SQL Server 2008.
VFP export to Excel only exports to XLS format which is upto MS Excel 2003. It is capable of maximum rows = 65,569. I want to export more number of rows.
How to Export to MS Excel 2007 so that the number of records exported can be increased as per Excel 2007 capabilities of maximum 1 million rows?
Is it possible in VFP9?
If not Is it possible through .NET using a VFP table or SQL Server directly?