>OK i get a connection now
>but this :
>
>
>
>gnConnHandle = SQLCONNECT("SQL")
>
>*SQLEXEC(gnConnHandle , [select * from contacts],"cc1") &&& works
>
>
>
>
>SQLEXEC(gnConnHandle , [INSERT INTO dbo.contacts (firstname,lastname) SELECT fname,lname FROM kba_data.contacts])
>
>SQLDISCONNECT(gnConnHandle )
>
>
>does not insert anything
>
>how would i do that correctly
>
Where is kba_data located? Is that the same SQL database or on the same SQL server?
>
>Peter
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________