Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Using Connect browser SQL syntax with an ODBC connector
Hi There
I have followed the instructions in the Netsuite help guide to set up a connection to Netsuite from Excel using an ODBC driver (windows 64bit).
This connected correctly and I was able to see the table names and query them using table names in the records browser schema.
However, how would I run queries using the table names and syntax of the connect browser?
For example, the help guide references the service_items table
This table only exists in the connect browser per the above screenshot and not the records browser (screenshot below)
When I try to use that exact query, I get the following error message:
Tagged:
0