Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

JDBC is an adapter layer from Java to SQL: it gives Java developers a common interface for connecting to a database, issuing queries and commands, and managing responses. Step 2.