How many rows of data? Is it too many to step through the vfp contacts table (scan...endscan) and do an insert into sqlserver contacts table ?


>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' ")