I'm trying to add to a table in SQL Server by creating a connection in VB.NET. The table has very many columns. I can currently open the connection and write just fine, but I'm not sure I'm doing it ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...