You need to sign in to do that
Don't have an account?
MeighanSF
Over 1k Matching xls files to Cleanse
It is pre-Salesforce import, I have designed the Named Account structure inside Salesforce, and I have 1500 Hoover's D&B Family Trees with the same columns and headers in .xls form. What do I use to mass clean these files so we do not import bad data? Do I try a batch import of the folder via the dataloader but say in SF if column equals don't import so it errors via a VR? Do I clean else where? Access? Too many rows for excel... Batch import? Use SharePoint? Please help my data find a way home...
Shashank (Salesforce Developers)
You may want to take a look at data.com clean: https://help.salesforce.com/HTViewHelpDoc?id=data_dot_com_clean_clean_overview.htm&language=en_US