I have a SQL server 7.0 and Access 97. I tried to retrieve data from Access
into SQL server using openrowset function and got an error :OLE DB provider
'microsoft.jet.oledb.4.0' reported an error :'[OLE/DB provider returned
message: Could not find installable ISAM.]'. Can some tell me what is wrong
and what should I do to fix it.

My query looks like:

select * from openrowset("microsoft.jet.oledb.4.0", "d:\www_web.mdb",
customer)

Thanks in advance.

Dan

USE pubs
GO
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'c:\northwind.mdb';'admin';'', Orders)
    AS a
GO

The problem is just that you're not passing the authentication information
(username and password); Jet, by default, uses Admin and no password.

Steven Bras, MCSD
Microsoft Developer Support
Visual Basic WebData

Thanks a lot. It works.

Dan