| yemimobolade 2006-10-24, 6:40 pm |
|
Has anybody figured out this problem yet. I am also having the same
problem Philip is. Please help.
Philip McComish wrote:
> *Recently the error message below started appearing when running a
> query
> against simple Excel spreadsheets.
> In the past this worked perfectly. Donīt know if the recently applied
> SP4
> might have anything to do with it.
>
> System:
> SQL Server 2000 SP4 on Windows 2000 SP4
>
> Error:
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [Microsoft][ODBC Excel Driver]
> System
> resource exceeded.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL'
> IDBInitialize::Initi
alize
> returned 0x80004005: ].
>
>
> Query:
> SELECT * FROM OpenRowset
> ('MSDASQL', 'Driver=Microsoft Excel Driver
> (*. xls);DBQ=c:\Temp\Tes
t',
> 'SELECT * FROM [Plan1$]')
>
> Any tips?
>
> Thanx in advance,
>
> Philip *
--
yemimobolade
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1704545.html
|