function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AGMAGM 

Importing Accounts with "The" in the Account name

Good Day All,  I'm new here and to SF so bear with me.  I have 2 questions.

 

1.  I am suing Apex Data Loader 10 as my importer of choice for SF.  Is the Excel Connecter still around and which would be easier to use?

 

2. When importing Accounts to SF using the SF Import Wizard any attempt to import an account with the word "The" in the name results in SF seeing the new account as a duplication and not importing.  For example. an account exists in SF called The Chateau Hotel .... try to import Chateau Hotel and SF treats it as a duplicate and does not create the account.  We are in a business that has many such situations and they are unique accounts.  Any way around this problem with the import?

 

Thanks in advance,

Andrew