Expose Custom Tables / ALL Tables and make them Visible / Available as ODBC Views in Excel when using Microsoft Query

There are times where Excel thinks that there are no visible tables while we already went through all of the steps in the documentation including: 1)      Enabling ODBC Connections for Advanced Reporting 2)      Enabling Global Permissions for employees and setting Advanced Analytics permissions for my login 3)      Installed Open SSL and NetSuite ODBC Driver   Note: This problem is only appearing when trying to open tables using Microsoft Query but not using custom odbc. See navigation and image (Excel > Data > Import External Data > Import Data > netsuite.com ODBC datasource)     Requirements: 1.        Microsoft Excel (Recommended: version 2000 and later) 2.        OpenSSL – Download it here. 3.        NetSuite ODBC Driver – Download it here.   You can work around this as follows:   1.       Install OpenSSL, SSL Encryption package is required for NetSuite ODBC feature. 2.       Download and Install the NetSuite ODBC Driver Client. Follow the steps in the installation wizard. 3.       Open Excel. 4.       Data > Import External Data > New Database Query > Netsuite.com > Enter login information when prompted.                 5.       From the Query Wizard – Choose Columns dialog, click the Options button. 6.       From the Table Options dialog, check or uncheck the System Tables checkbox. Click the OK button                   7.       Verify the tables are displayed in the Query Wizard, Choose Columns dialog.

Note: For Excel 2010 1. Data tab > From Other Sources > From Microsoft Query 2. Select the DSN you have created, enter your credentials