I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server) using SQL scripts.
I tried following :
select * into TEMP_PLAN_CODE FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 10.0;Database=D:\Placodes.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')
but it's giving me an error :
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.
I can't create linked server as well and can't run BCP (no authority)
What are my available choices for copying XLS (on local) to SQL (not local) tales using SQL scripts and not using any .NET code.
Thanks in advance