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?
I found this, if anyone else needs it.
Try saving it as .xlsb instead. Google sheets doesn’t seem to be able to open that format – at least at the moment.