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.
| 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 |
|
|
|
|
|
|
Could not find installable ISAM