I am using 2008 R2 and trying to build an Excel file from data within SQL
I am using the following code
SET @SQL=N'INSERT INTO OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 8.0;HDR=YES;DATABASE='+@FILENAME+''',''Select * from [Whitelist$]'')SELECT PHRASE FROM dbo.TBL_PHRASE WHERE TID = '+@TID+''
where @filename and @tid are declared varchar values
i have to use @filename as the excel file is unique every time and has a changing filename
I get the following error :
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
My server is 64 bit and i have Microsoft.ACE.OLEDB.12.0 in the provider list within linked servers - all options are unchecked except Dynamic Parameter
I think everything else is enabled on the server
the folder in which the file sits has rights for everyone set to full access
