Trying to export more than 65,xxx records to excel

[JDcruiser33]

Hi there,

I've got a bunch of tables that sometimes have more than 65,xxx records (older version of excel's maximum rows). When I export to excel, it basically has to stop at 65,xxx and cannot export anymore.

Ideally, I'd like to have it export the remaining to a new worksheet within the file.

What's the best way to handle this? Via export script? Or external to FM? And how?

Thanks!

[Kris M]

Create a found set of the first records that will fit into excel then export those. Go to the next set of records that will fit into excel and export those. Repeat till all the records that you want are exported. If you want more detail on exactly how to accomplish this i (or anybody else i think) would need more information about your data.

[JDcruiser33]

Thanks! I think I understand your suggestion. So basically I'm going to find the first 65,000, export, the next 65,000, export, the next however many, export, and end when no more are found.

When I first thought about this problem, I realized there seemed to be many different strategies...yours sounds pretty simple. I'll try it out. Thanks again!