How do I setup SuiteConnect to link to Excel throu...
# ask-stanley-ai
a
How do I setup SuiteConnect to link to Excel through ODBC. Where do I add in the SQL query?
c
AI generated answer (using internal Slack threads):
To set up SuiteConnect to link to Excel through ODBC and add in the SQL query, follow these steps: 1. Ensure that you have the SuiteConnect module/plug-in. This is necessary for ODBC connectivity in NetSuite. 2. Create an inbound connection from your application. This is done through the SuiteAnalytics module in NetSuite. 3. Build the appropriate SQL queries. These queries will be used to pull data from NetSuite into your application. 4. Note that NetSuite is passive in this process. It's not so much that NetSuite is exporting data, but that your application (in this case, Excel) is importing it. 5. Be aware that some users have reported issues with 32-bit ODBC connections. You may have more success with a 64-bit connection, especially if you're using a 64-bit version of MS Office. For more detailed instructions, you can refer to this NetSuite help article: https://netsuite.custhelp.com/app/answers/detail/a_id/68320/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838907301
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8343907
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831775784
Please provide your feedback on this answer.
Thank you for your feedback