Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.

Creating and using an SQLite database for data persistence in Android apps. Covers the basics, as well as using foreign keys. Full source included.

A developer shouldn't spend time on database table creation when unit tests run. Instead, have Hibernate create tables in the database for JPA and other data-driven applications.