excel tables
- From: "nkg" <sunil_godiyal@xxxxxxxxx>
- Date: Fri, 12 Jan 2007 13:11:26 -0600
I configured excel file as a linked server in Sql Server using Jet OleDB
provider.
When i run sp_tables_ex i get tables names as follows .
Dealers$
Cars$
Dealers$_
Cars$_
when i run EXECUTE SP_columns_ex excel,[Cars$_],null,null,null
i get following error even though i did not request for Dealer$_
OLE DB provider "SQL Server" for linked server "(null)" returned message
"The Microsoft Jet database engine could not find the object 'Dealers$_'.
Make sure the object exists and that you spell its name and the path name
correctly.".
Msg 7311, Level 16, State 2, Procedure sp_columns_ex, Line 269
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "SQL
Server" for linked server "(null)". The provider supports the interface, but
returns a failure code when it is used.
can any one tell what are these tables with underscores in them.?
TIA.
.
- Prev by Date: Re: delete operation blocked by an open select in different CSession
- Next by Date: Excel Query Over Matching
- Previous by thread: Correct way of using OleDbDataAdapter and DataSet to update Access database?
- Next by thread: Excel Query Over Matching
- Index(es):
Relevant Pages
|
