If you cannot install a System DNS, then the following steps should work:

1. Install SQLite ODBC driver from Ch. Werner (both 32 and 64 bit?)
2. In SSMS, go to Server Objects > Linked Servers > New Linked Server...
3. In the window enter:

• Linked server: EXAMPLE (or anything)
• Provider: Microsoft OLE DB Provider for ODBC Drivers
• Product name: example (or anything)
• Provider string: Driver=SQLite3 ODBC Driver;Database=full-path-to-db;

You should now be able to query the SQLite DB with

SELECT * FROM OPENQUERY(EXAMPLE, 'SELECT * FROM tbl_Postcode;')

as mentioned above.

If you cannot install a System DNS, then the following steps should work:

1. Install SQLite ODBC driver from Ch. Werner (both 32 and 64 bit?)
2. In SSMS, go to Server Objects > Linked Servers > New Linked Server...
3. In the window enter:

• Linked server: EXAMPLE (or anything)
• Provider: Microsoft OLE DB Provider for ODBC Drivers
• Product name: example (or anything)
• Provider string: Driver=SQLite3 ODBC Driver;Database=full/path/to/db;

You should now be able to query the SQLite DB with

SELECT * FROM OPENQUERY(EXAMPLE, 'SELECT * FROM tbl_Postcode;')

as mentioned above.