Need to extract all the records in a SQL server DB table and store in a excel file. Am trying to use distributed query
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [TEST$]') SELECT * FROM dbo.table_name
I have requsted for rights to perform this query.
The question is can i execute this query from java through the standard JDBC application program interfaces (APIs) using sqljdbc.jar?
I would have tried this but am waiting for the rights to execute distributed queries