>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only