I need to export port a file which has over 400 fields and years of data. When I try to export I get the following error.
is there a way to split the data into chunks? I still need all the data, and would like to split in yearly chunks. Is there a simple way to do this? I am a total novice at this.
Best answer by MarkShnierYou
Sure, just make a report and include all the fields. There is an option under the more menu or the 3 dots menu to export or save as spreadsheet.
So then the issue is how to chunk the data into several exports. It depends on bow large you data set is in terms of rows, but for example you can make a field called [Last Digit of Record ID#] with a formula of Right(ToText([Record ID#]),1)
That will give you a text value between 0 and 9, and you can play with report filters to see if you can get away with exporting half at a time or if necessary 1/10th at a time, or somewhere in between.
+22Sure, just make a report and include all the fields. There is an option under the more menu or the 3 dots menu to export or save as spreadsheet.
So then the issue is how to chunk the data into several exports. It depends on bow large you data set is in terms of rows, but for example you can make a field called [Last Digit of Record ID#] with a formula of Right(ToText([Record ID#]),1)
That will give you a text value between 0 and 9, and you can play with report filters to see if you can get away with exporting half at a time or if necessary 1/10th at a time, or somewhere in between.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
