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).<br>
<br>-- <br>Tyler Style<br><a href="http://www.malthusian-solutions.com">http://www.malthusian-solutions.com</a><br><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div style="text-align: left;">
Date: Wed, 22 Apr 2009 12:13:05 -0700 (PDT)<br>
From: Richard Hane <<a href="mailto:yoresoft@sbcglobal.net">yoresoft@sbcglobal.net</a>><br>
Subject: filepro to sql<br>
<br>
OK it's time for wierd question of the day.<br>
?<br>
Has anyone populated a SQL (either Microsoft or mysql) database directly from filepro?? If not have about MS-Access?<br>
?<br>
I am pretty sure this could be done with Excel either dif or csv but I am trying to do this seemlessly.<br>
?<br>
Thanks in advance,<br>
Rick Hane<br>
Controller<br>
Deluxe Stitcher Company Inc</div></blockquote><a href="mailto:rhane@deluxestitcher.com"></a>