This says the server is created but now I want to select info from a datarange in this spreadsheet. The books online says to use
FROM ExcelSource..Quarter(Quarter being the datarange)
but when I try to execute I get the error...
Server: Msg 7314, Level 16, State 1, Line 4
OLE DB provider 'ExcelSource' does not contain table 'Quarter'. The table either does not exist or the current user does not have permissions on that table.
OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='ExcelSource', TableName='Quarter'].
I am kind of new with this so I am not sure what the problem is??? Is the select set up wrong??? any suggesstions?