I have 4.6 million records in my database that I want to export to excel. However, Excel has a row limit of about 1 million per worksheet. The export stops and does not roll on to the next sheet.
Is there a way to have filemaker continue exporting to the 2nd, 3rd sheet ?
Thank you!
Not natively. You can write your script in FM to do separate exports and then manually combine them in one excel workbook, or use the Excel automation tools to do that for you. You could trigger that from inside FM if it has to be a seamless process but it will require working with the Excel APIs.
That means Excel can't work with such large data. So why do you need it for Excel format? CSV or merge will be better for after process.
Not natively. You can write your script in FM to do separate exports and then manually combine them in one excel workbook, or use the Excel automation tools to do that for you. You could trigger that from inside FM if it has to be a seamless process but it will require working with the Excel APIs.