filepro to sql

[Tyler]

I do this all the time using some custom programs that 1, take filePro table
definitions & maps them to MySQL datatype equivalents and cleans out illegal
files name characters, and 2, uses a rules table to determine what the SQL
statements should be for a given set of records, pumps out the script, and
then issues a system command to a mysql client to upload it.  It was
actually quite easy to set up and has worked flawlessly.  It's especially
handy if your DB schema doesn't match your filePro file structures (mine
definitely doesn't).

-- 
Tyler Style
http://www.malthusian-solutions.com

Date: Wed, 22 Apr 2009 12:13:05 -0700 (PDT)
> From: Richard Hane <yoresoft at sbcglobal.net>
> Subject: filepro to sql
>
> OK it's time for wierd question of the day.
> ?
> Has anyone populated a SQL (either Microsoft or mysql) database directly
> from filepro?? If not have about MS-Access?
> ?
> I am pretty sure this could be done with Excel either dif or csv but I am
> trying to do this seemlessly.
> ?
> Thanks in advance,
> Rick Hane
> Controller
> Deluxe Stitcher Company Inc
>
<rhane at deluxestitcher.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090422/31c53990/attachment-0001.html