You need to sign in to do that
Don't have an account?
Julie Curry 19
Salesforce Data Loader Export too large
I want to export 2.7m records using Salesforce Data Loader. I'm doing this in UAT and mostly it seems fine. I want to export these records to have them on file because we want to delete them from Salesforce.
The problem is that the export file (excel) will only show a little over 1 million rows. I'm not sure if there is a way to export into multiple files. If there is please let me know.
Alternatively, I was trying to add criteria to break out the export by record created date, but I can't get the formatting to work. I've tried a couple of things that look like '2013-06-11T13:54:00Z' but neither of them produces any records. I don't get an error but I don't get any records.
Can anyone provide suggestions on how to best do this? If I just jump straight to deleting the data will Data Loader return a file to me with the data that was deleted? Or maybe Workbench is the better option?
Thanks in advance for your help!
The problem is that the export file (excel) will only show a little over 1 million rows. I'm not sure if there is a way to export into multiple files. If there is please let me know.
Alternatively, I was trying to add criteria to break out the export by record created date, but I can't get the formatting to work. I've tried a couple of things that look like '2013-06-11T13:54:00Z' but neither of them produces any records. I don't get an error but I don't get any records.
Can anyone provide suggestions on how to best do this? If I just jump straight to deleting the data will Data Loader return a file to me with the data that was deleted? Or maybe Workbench is the better option?
Thanks in advance for your help!
Data Loader is supported for loads of up to 5 million records.
Please find below approach.
How to export over 2.7 million records using dataloader
https://developer.salesforce.com/forums/?id=906F00000008n1wIAA
You can try opening the excel file from access
https://www.wikihow.com/Import-Excel-Into-Access
Also you can check available App Exchange tools.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks,
Vinay Kumar