MS Excel can be used to connect to NetSuite ODBC interface:
- Open a new sheet in Excel.
- Navigate to Data > From Other Sources > From Data Connection Wizard
- Choose ODBC DSN, click Next
- Choose NetSuite.com, click Next
- In the login dialog, enter NS email and password
- Wait for the dialog box where the database and tables can be selected. Uncheck the checkbox "Connect to specific table" to select multiple tables
- Follow other dialogs to complete the report
This feature is available in MS Excel 2010 and newer.
No comments:
Post a Comment