>I am using the upsize wizard in Visual Fox 7.0 and and getting the message:
>
>4861 records not exported on some of mu fox tables. Other ones upsize ok. I took one of the tables and stripped out all of the compound indexes, and only had 3 character fields and still I get the error. I then deleted all of the records except for one to see if it is a data issue, still the same.
>
>Has anyone seen this error before?
>
>Thanks
1) Do you have any filtered index - i.e. "FOR NOT DELETED()" or any other VFP expression in the index expressions?
Those cannot be translated into TRANSACT-SQL syntax
2) Use the option "Generate upsize report" and get extended error information from there.
HTH and bye
Jose.