using ODBC and sql server to consolidate smartsheet tables
Hello community. Day 1 for me. My company is looking to bring the smartsheet data back in-house for consolidated reporting purposes. MSSQL is our shop. I am looking at the ODBC connector and it looks like the ODBC shows each sheet as a separate table. I'm looking consolidate these sheets into 1 sql table.
Has anyone done this with the ODBC connector? I'm thinking of creating a linked server with this ODBC connector and then writing sql to consolidate all of this. Thanks for your time in advance.