fpODBC to SQL question

[Richard Kreiss]

From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
Behalf Of Richard Hane
Sent: Wednesday, January 20, 2010 12:34 PM
To: filepro-list at lists.celestial.com
Cc: Rick Hane
Subject: fpODBC to SQL question

 

For years I have been updating our plant mgt apps in fileProODBC using
Excell spreadsheets.  Th Excell sheets have a link to our ERP databases
written in Microsoft SQL Server.  Each night I update 9 spreadsheets and run
a batch file that updates filePro. Since I will be retiring in the near
future I need to make this function simpler.  The answer would seem to be to
use the ODBC portion of fp.

 

My question is rather basic.  Which method High Level or Low Level (as
listed in fp) would I need to use.  Note I am not writing data back to SQL
only reading data and updating fp.

 

Thank you,

Rick Hane

Controller

Deluxe Stitcher Company Inc

www.deluxestitcher.com

 

 

Although Ken recommended using low level to go directly to your SQL
database, one other solution would be to create an intermediate filepro
file(s) mapped to the sql file(s). You can then write any processing needed
to update your filepro records from the intermediate file.  Not an elegant
solution but should work with a minimum of programming.

 

 

Richard Kreiss
GCC Consulting

rkreiss at gccconsulting.net
  

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100120/c829e41d/attachment-0001.html