Could not find installable ISAM

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

Could not find installable ISAM

Author

Topic

Mamatha
Posting Yak Master

102 Posts

Posted - 2005-04-01 : 10:28:59

Hi

I am using the following query to import SQL table into Access but i got error "Could not find installable ISAM" while executing ASP page.

set lcnn = Server.CreateObject("ADODB.Connection")

lcnn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
_
"Dbq=db1.mdb;" & _
"DefaultDir=d:\;" & _
"Uid=Admin;Pwd=;"

lcnn.Execute("SELECT * INTO " & _
"[tblpath] " & _
"FROM " & _
"[Driver={SQL Server}; " & _
"SERVER=sreeni;DATABASE=parameter;" & _
"UID=sa;PWD=thanks;]." & _
"[tbl_path];")

'lcnn.Execute SQL
Set lcnn = Nothing

Please give me any solution.

Thanks in advance.

Mamatha

Mamatha

jhermiz

3564 Posts

Posted - 2005-04-01 : 10:35:25

Try this link:

http://support.microsoft.com/kb/209805

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

Mamatha
Posting Yak Master

102 Posts

Posted - 2005-04-02 : 05:16:17

Hi

I already visited this link,but i can't find releavent information from there,because my problem releated to Access and SQL.
That site gives information for all products of Microsoft office other than Access.

Please give me any other solution.

Mamatha

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources