Need assistance with fpODBC

[Richard Kreiss]

Top post:

Fp does not read Excel files. 

What I would suggest is creating Access files linked to your Excel file. Then connect Fp to the that
access file for the import. 

I used Access as a way to link a client's fp application and UPS World Ship.   it is using their shipto file so this info only needs to be entered once and is maintained centrally.



By doing this, I don't gave to account for changes in the WorldShip data structure. UPS Handles the mapping. 

The other import from WorlsShip is at the end of the day. We import from a csv file created with the end of day reports, the daily tracking information.

Richard Kreiss
Sent from my iPhone

On Oct 23, 2012, at 9:04 AM, Richard Hane <yoresoft at sbcglobal.net> wrote:

> 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 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list