Error 7314

Last Post 22 Jan 2009 07:35 PM by PaulMcKibben. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
19 Jan 2009 02:57 PM
I receive error 7314 when I execute the following SQL query to import data from an Office 2007 excel spreadsheet:

select * into dbo.states
from openrowset('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\States1.xls',[Sheet1])

The text for 7314 is:

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Sheet1". The table either does not exist or the current user does not have permissions on that table.

The spreadsheet and sheet names are correctly named and spelled.

Your help is appreciated.
PaulMcKibben
New Member
New Member

--
19 Jan 2009 03:08 PM
Yes, it is.

OS is XP.
PaulMcKibben
New Member
New Member

--
22 Jan 2009 07:10 PM
It is not Sheet1$.

PaulMcKibben
New Member
New Member

--
22 Jan 2009 07:35 PM
The Excel 2007 file extension is xlsx. When I change the query statement to reflect this:

select * into dbo.states
from openrowset('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\States1.xlsx',[Sheet1])


Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

are returned.
You are not authorized to post a reply.

Acceptable Use Policy