FAQs
FAQs
SETUP QUESTIONS/ERROR MESSAGES
Error connecting to Sage - Invalid or incorrect username or password
.Net Error: Not connected to Data Source - Connect or Logon failed
The username\password being used in the E2S Connector has not been setup correctly in the Sage company being accessed.
Our default user is connector with a password of p@ssw0rd
If you wish to use a different user, ensure name and password match in Sage and E2S
For more information see Adding a Dedicated Sage User for E2S
Cannot open SETUP.DTA - showing in the Company Control Tab of the E2S Connector
This may occur when your Sage data is held on another machine, (usually a server), and the E2S Connector cannot find the Sage Company names held in the local registry.
We recommend using UNC paths not mapped drives
Instead of W:\Sage\Accounts\2026\Company.000\Accdata use \\YourServerName\Sage\Accounts\2026\Company.000\Accdata
With the default installation, companies are filled in automatically if possible. To amend the path used by E2S, tick the Update Companies Manually Configuration key and edit the data yourself in Company Control tab.
Double click in the field to manually type the names of your Sage companies.
For more information see: Company Control
.NET Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
The Access Database Engine file is provided with the setup of E2S and is offered as part of the install process.
This error is a result of missing data connectivity components from your MS Excel, you will need to reinstall the driver to run which should resolve this issue.
This will be found here: C:\Excel2SageConnector\AccessDatabaseEngine.exe
If you don't wish to run this Microsoft file on your system, please switch on the Enhanced Excel Checks on the E2S Configuration screen.
TROJAN Warnings - False positives from your Antivirus software, typically Norton/Symantec
The article below from Symantec explains false detections on some software, our E2S software is 100% virus free.
Symantec- Handling and preventing SONAR false positive detections: https://support.symantec.com/en_US/article.HOWTO55273.html
How to prevent UAC requiring Admin password for users of E2S
Go to C:\Excel2SageConnector
Right click and select Properties\Security
Edit and select Users (or named user profile if required) and tick Allow Full control, then Apply, then OK.
The desktop shortcuts created during installation will need to be recreated if required.
Unable to connect to the Sage Data Service on machine …
The RPC server is unavailable (Exception from HRESULT: 0x800706BA)
Error connecting to Sage – The remote procedure call failed
The pop-up screen warning that the remote machine may not be switched on or connected to your network.
If you are able to connect to Sage normally, this would indicate that there are insufficient permissions for the E2S software to connect to the Sage data folders on the remote server.
Your IT department will need to grant permissions accordingly on the remote server.
USAGE QUESTIONS/ERROR MESSAGES
Error connecting to Sage - Username is already in use
You may get this message if E2S failed to log out when last used.
Check in Sage in the “User List” to see the active users, and remove connector.
Alternatively, log in and out of Sage as the user connector to clear the session.
NOTE: Default user is connector with a password of p@ssw0rd
Error connecting to Sage - Program is in exclusive mode. Logon cannot proceed
Sage is busy doing a backup - once completed E2S will be able to connect as normal.
Error connecting to Sage - data files are wrong version
Select the relevant Sage version from within the E2S Connector > Configuration tab.
or download the latest version of E2S software should the version not be listed in the Configuration tab.
The help page Changing Your Sage Version will give you more information.
If you are using E2S as part of a larger solution provided by Red IT, please contact support@red-it.co.uk for more information or assistance.
We strongly recommend informing us of any intended upgrade before upgrading your Sage Software so we can anticipate and schedule any additional work that maybe required to keep your site up and running.
Error reading Excel data. Check all fields are present.
Refer to Help file for details of all fields required for this load.
Circular reference caused by alias ‘’ in query definition's SELECT list
For more information see: New Fields
The Run Button is greyed out
Your licence is not valid. This could be because a trial licence has expired or the machine name does not match the licence. Please check with support@red-it.co.uk
For more information see: Licensing
Data type mismatch in criteria expression
Error getting data from Excel - Numeric Format
If you are using the default excel reader, the data in a field is in the wrong format, the most common is the InvRef field. If you have only entered a number in this field, MS Excel is likely to have formatted the field into a Number format.
Either prefix the first number with an apostrophe ' which makes MS Excel leave the number as text or use an alpha-numeric reference for the InvRef field to prevent MS Excel from auto-formatting the field as number.
By enabling the Enhanced Excel Checker functionality, this error can be prevented.
Setting in E2S Configuration (Enhanced Excel Checks ticked)
Invalid value specified
Check that all data is within field length specified in the Field Mappings stored in the help file
For more information see: Excel File / Tabs Field Mappings
Can I rename or delete some of the columns that I don't need?
Field names need to match precisely to our template, but can be re-ordered as required.
With Enhanced Excel Checker enabled, optional fields (yellow headers) can be removed and E2S will add them with no data populated.
With standard configuration, all headers need to be present as detailed in the field mappings and provided in the template provided with the software.
If columns are hidden, any data in them will still be loaded to Sage.
Can I copy and paste data into the E2S Import Spreadsheet?
Yes, it is always advisable however when pasting data from another source to paste
“values”
This can be done by right clicking and selecting Paste Special and then opting
for Values.
Will E2S still work if I upgrade my Sage software?
The help page Changing Your Sage Version will give you more information.
You may need to upgrade your E2S software, but this is covered within your support agreement.
For more information see: Upgrading
Can I check the Excel data before importing?
To review the data before running an import, click the Excel sheet icon in the top-right hand corner of E2S.
Hovering over the icon will display “Open Excel Sheet”
Selecting this will open the current “Set to Load” Excel sheet, allowing you to view, verify or edit the data prior to import.
LICENCING QUESTIONS
I have a new PC has died and my E2S license key doesn't work on the new PC?
E2S Software licences are tied to a single machine name.
You can download a new trial version of the software from our website, and purchase a licence transfer for the remainder of your current licence. This will include assistance with setting up and configuring the software to match your old machine.
For more information contact support@red-it.co.uk or accounts@red-it.co.uk.
How do I renew my licence?
Annual licences need to be paid for in advance of a new licence being issued.
You will receive an invoice by email approximately one month before renewal with bank transfer details for payment.
For more information contact accounts@red-it.co.uk