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!
General Error/Warning
So i've setup the ODBC driver and OpenSSL as required, I then went into Excel (2007) to try a test run. I choose Data> From Microsoft Query (ODBC).. Choose my datasource "Netsuite.com".. then hit ok. It prompts me for my username and password which I provide (its the administrative account). I then get a dialog box called "Query Wizard - Choose Columns".. this is where my problems begin.
I am able to see the list of available tables. However, I cannot expand any table to view the columns and I cannot add any to the query. It throws an error "Unable to connect to the data source". Thought I WAS connected. In access I try the same kind of setup only to receive a "General Error/Warning" error.
0