hi ,
i am using DAO 3.6 to cpy some data from the MS-sql 2000 to Access database.
i have two connection objects,
One for access and other for SQL

the query is use is-->

ssql="select * into userdeftable from [Server=Servername;Database=IMAGEDATA;UID=sa;PWD=Pa ssword1;].[UserDefTable] "

gsdatabase is the database pointing to Msaccess

On executing
gsdatabase.execute (ssql)
i get error as
Runtime error 3170
Coud not find installable ISAM

any comments!
regards
ajay