>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
>
>
>Peter

If kba_data is a database on the same SQL Server, then try:

SQLEXEC(gnConnHandle , [INSERT INTO dbo.contacts (firstname,lastname) SELECT fname,lname FROM kba_data.dbo.contacts])

Also always test the return value of SQLEXEC and use AERROR() when it's -1.