I am trying to get local vfp data stored in kba_data.contacts (dbf) into a new sql2080 database called cmc
i have tried theupload wizards and they fail


Peter



>>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
>>
>>
>>Peter
>
>what is the database name that holds contacts that you are inserting into? (Put correct stuff where square brackets are)
>
>SQLEXEC(gnConnHandle, "INSERT INTO [databasename].dbo.contacts (firstname, lastname) SELECT firstname, lastname from kba_data.dbo.contacts WHERE [add where condition here]"
>
>So if the database you are inserting into is kbb_data and you only wanted to insert records from kba_data that had the firstname of John:
>
>

>SQLEXEC(gnConnHandle, "INSERT INTO kbb_data.dbo.contacts (firstname, lastname) SELECT firstname, lastname from kba_data.dbo.contacts WHERE firstname = 'John' ")