>>>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.
Bob Tracy
Never engage in a battle of wits if you're only half armed.