Need assistance with fpODBC

[Richard Hane]

We need help setting up our fpODBC.  I have over 30 yrs with fp. I also do a lot of transferring of data between our MRP software (written in Microsoft SQL Server)  and fp via the ODBC link in Excel.  I even took the class in Indy on the ODBC.  That all being said I don't have the time to play with this and need it setup PDQ.
 
A short description of what we do.
There are about 15 Excel
spreadsheets I import every day, from MRP then read in to filePro.  All I
am looking for the fpODBC to do is eliminate the need for the spreadsheets and
read the data directly.  It does not need to be live data as a record is
called up during the day, rather just a daily update process that I would set as a scheduled task.Before someone asks; we do not allow external access to our systems.  No exceptions.  So this might have to be an on site help. I can provide a copy of each of
the spread sheets with data and field names.  Obviously also include the
table name.  What I would need from you is how to set up the link ( I had a problem when I tried to do this 3 years ago) and write the process to do
the importing.  Probably Only need you to show 1 of the processes.  The rest I can write.
 
I am assuming (insert joke here) 3 - 5 hours.  We would like to hire someone for that time.  It would have to be someone local or who comes to the Chicago area on occasion.
Email me at either address listed below or call me at the number listed.
 
Thank you in advance,
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
rhane at deluxestitcher.com
yoresoft at sbcglobal.net
773-777-6500
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20121023/cd05becb/attachment.html