Success MS SQL server to fpODBS

[Richard Hane]

As some of you may have noticed from my postings, I have been trying to get our ERP system (written in MS SQL server) to update automatically to our filePro ODBC files.  I am happy to say that with the great help from Robert Haussmann and Ken Brody I was able to write a process that copies my product file from ERP and updates the product file in filepro.
 
I was most impressed with the speed. A 17,000 part file transferred in 45 seconds. This is on a 16 user system.  When complete this will save me an hour a day.
 
Because help and samples of processing on this topic were so hard to find, I am willing to send or post the processing for others who may have a need.
 
If you would like to see it, send me a note (off list) and I will send it.  It will be in a week because I now must write 9 other processes for other tables.  This should not take long as all I will have to do is change the table name and field names.
 
Again many thanks to Bob and Ken.
 
Rick Hane
Controller
Deluxe Stitcher Company Inc
http://www.deluxestitcher.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130410/88916933/attachment.html