Home

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
Cancel
2 Answer(s)

I found this, if anyone else needs it.

 https://www.excelforum.com/excel-formulas-and-functions/1352251-prevent-xlsm-spreadsheets-from-opening-on-google-sheets.html
excelforum.comexcelforum.com
Prevent .xlsm spreadsheets from opening on Google Sheets [SOLVED]
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 🙂
Cancel
Beginner Answered on July 11, 2022.
Add Comment
Cancel

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

Cancel
Beginner Answered on July 11, 2022.
Add Comment
Cancel

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   Limebox   Become a Sponsor   Become a Sponsor