Hi Yes it is possible to open any sql server from within management studio when you have the correct odbc driver to do so. Create an ODBC connection to the *.db3 file and call it something like SQLite then try this is a query window
-- needs to be a system odbc connection not user
EXEC sp_addlinkedserver
@server = 'SQLite', -- the name you give the server in studio
@srvproduct = '',
@provider = 'MSDASQL',
@datasrc = 'SQLite' -- the name of the system odbc connection you created
GO-- needs to be a system odbc connection not user
EXEC sp_addlinkedserver
@server = 'SQLite', -- the name you give the server in studio
@srvproduct = '',
@provider = 'MSDASQL',
@datasrc = 'SQLite' -- the name of the system odbc connection you created
GO
This is how you get the data, you can create views using this sql as well if you like
SELECT * FROM OPENQUERY(SQLite, 'SELECT * FROM tbl_Postcode')
SELECT * FROM OPENQUERY(SQLite, 'SELECT * FROM tbl_Postcode')
