Hi I get this error when running an OPENROWSET command to import data from an xls spreadsheet into a table: "Msg 7415, Level 16, State 1, Line 4 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've already enabled the AdHocRemoteQueriesEnabled setting u...
I want to clarify how I could import data from .csv into table with 3 columns (see CR Ranking.csv below). My query: select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=C:\Work\;HDR=Yes;', 'SELECT * FROM [CR Ranking.csv]'); Outputs results into one coulmn: header: Category;INfo;Rank row 1: Category 1;Info;1 row 2: Ca...
Basically I am looking to select the contents of a pdf into a table. I am using this query: SELECT * FROM OPENROWSET(BULK N'\\Server\Share\filename.pdf', SINGLE_BLOB) rs The query won't run because my username doesn't have permissions on that server (nor should it), but I need to be able to authenticate as a different user to execu...