>>>>For several days I've been trying to find an easy way to dump my FoxPro table(s) onto our MS SQL Server programatically (without using the Upsizing Wizard). I was curious how the rest of the FoxPro community was doing this.
>>>>
>>>>APPEND FROM into a remote view didn't seem to work; only kept first 200 records. Please help!
>>>
>>>Have you tried using SQL Pass-through? You could loop through all the records in the table and insert them one at a time. A little brute force, but it should work.
>>>
>>>HTH
>>
>>Also, the last mean (although APPEND and pass-through should work) is to export data to text file, and import it to SQL-Server manually.
>
>I use the method that Edward suggests, I do an SDF copy to a text file and then BCP into SQLServer. It works quite well especially if your working with large VFP files. You can also automate the process if you perform it on a regular basis.


I usually create foxpro table that has the same characteristics as the SQL Server table. I then create an updateable view of the SQL Server table. This remote should have the same structure now as the VFP table. Then, with the view the active table, I do an append from the VFP table. I have never had a problem and have imported thousands of records at a time.