NetSuite ODBC to Google Sheets

We currently use our ODBCConnect with SQL database and Microsoft Excel to pivot, graph and report the data. We were acquired and the parent company uses Google Sheets instead of Microsoft Excel.

We need  to leverage our ODBCConnection to our SQL database and convert to Google Sheets.

Has anyone successfully accomplished this?  How?

Has anyone used ODBCConnect with Redshift and Google Sheets?  How?


Beginner Asked on July 7, 2022 in SuiteAnalytics Connect.
Add Comment
2 Answer(s)

I found this, if anyone else needs it.
Hi all, Is it possible to prevent my spreadsheet (.xlsm) from opening on Google Sheets? There are some array formulas and macros in my file that stop working in Excel if the file is opened on Google Sheets (even in Preview mode). I would like to prevent my colleagues from accidentally opening the file on Google Sheets. Solution: Making sure that the file is only downloadable. Any help is greatly appreciated! Thank you 🙂
Beginner Answered on July 11, 2022.
Add Comment

Try saving it as .xlsb instead. Google sheets doesn’t seem to be able to open that format – at least at the moment.

Beginner Answered on July 11, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor