JEClark
asked on
Import and Export data to Google Docs spreadsheet from MSSQL
Hi
I'd like to create a Google docs script which would import data from a Microsoft SQL database.
I'd also like to create a Google docs script which would write from my Google docs spreadsheet back to MSSQL.
Has anyone done this or seen example code?
Thank you.
I'd like to create a Google docs script which would import data from a Microsoft SQL database.
I'd also like to create a Google docs script which would write from my Google docs spreadsheet back to MSSQL.
Has anyone done this or seen example code?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As you pointed pointed out, the Secure Data Connector is deprecated.
I had looked at Zapier, bt want something I can control more granularly,
The Google example looks intriguing, but appears to be m ore directed to reading and writing from data that already exists on Google drive.
I think I will need to use JDBC as outlined on this link. https://developers.google.com/apps-script/guides/jdbc
Thank you for the excellent suggestion