>>>Hello guys I have another question
>>>
>>>I have this VFP DBC with 3 tables on it, in those tables I store a parse
>>>version of a very daily report.
>>>I had already upsize the VFP DBC to SQL server, on the VFPDBC I have
>>>remote views which represents the tables on the SQLserver.
>>>The question is I am able to populate the (remote)SQLserver views with
>>>the data coming from the VFPDBC tables:
>>>
>>>is there a way to insert this info onto the SQLServer tables ?
>>
>>Its quite easy actually. Assuming your new data is in the same format as what was upsized (and the upsize wizard already moved the data unless you told it not to). There are two possible scenarieos (so), 1. you want to completely replace what is on sql server with new data, and 2. you want to add to it.
>>
>>For number one, just open the remote view that had the same name as the original VFP table, and do a delete all on it. Then requery it, and append from your new source tables.
>>
>>For number two, open the remote view with the original table name, and append from your table that contains the new records. Its that simple.
>
>
>Hey thanks or that, I am actually doing it, I select the remote view and I issue an append to it.
>
>thanks

I am now getting invalid Insert erros , one of my columns named Date, it says it can not accept nulls values, weird since it has only appended only a row into SQL , in my FoxProtable I have about 100 rows.