Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
NetSuite ODBC Connection with MS Excel
Hello,
I am trying to access NetSuite data from Excel via NetSuite ODBC connector and the login info which I'm providing is of an Administrator account.
But it shows the following error:
"You do not have permission to use ODBC. Please contact your account administrator for assistance."
Before this, I have set up
1. Enable ODBC features and web services in Netsuite
2. Set Admin as default role and add it into web preference in Netsuite
3. Install a proper ODBC driver (64-bits)
4. Confiture: -OpenAccess Service Host=ODBCSERVER.NA1.NETSUITE.COM
-Open Access Service Port=1708 -OpenAccess Service Data Source= NetSuite.com
5. Test connection is okay in Data Source but it still does not work in Excel.