<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>[ Sorry top posted ]</span></div><div><span></span> </div><div><span>Thanks to all who helped. Ken please ignore my last email.</span></div><div><span></span> </div><div><span>I think I have it now although I am having trouble with the DSN connection. However, I think that has to do with the path.</span></div><div><span></span> </div><div><span>My confusion was that looking at the sample ODBC files I assumed there was someplace outside of the file you were updating to set the connection data, table, fields, etc. I'm sure when I took the class they probably told us this but it was 6-8 years ago and I am old and forget things.</span></div><div><span></span> </div><div><span>Again thanks to all who helped.</span></div><div><span></span> </div><div><span>Rick
Hane</span></div><div><span></span></div><div><font size="2" face="Arial">----- Forwarded Message -----<br> <b><span style="font-weight: bold;">From:</span></b> Rick Hane <rhane@deluxestitcher.com><br> <b><span style="font-weight: bold;">To:</span></b> Kenneth Brody <kenbrody@spamcop.net> <br><b><span style="font-weight: bold;">Cc:</span></b> file Pro Mailing List <filepro-list@lists.celestial.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, October 25, 2012 10:02 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: Need assistance with fpODBC<br> </font></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <br>
<br><br>-----Original Message-----<br>From: Kenneth Brody [mailto:<a href="mailto:kenbrody@spamcop.net" ymailto="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>] <br>Sent: Thursday, October 25, 2012 9:41 AM<br>To: Rick Hane<br>Cc: file Pro Mailing List<br>Subject: Re: Need assistance with fpODBC<br><br>On 10/24/2012 4:58 PM, Rick Hane wrote:<br>>>[... Populating a file from an ODBC "import" ...]<br>>><br>>> Thanks for the reply and information. Here is the info I copied from<br><br>>> the ODBC link in Excel.<br>>>[...]<br>>> From this I see most that I need to set up the ODBC Link in fp.<br>>> I looked through the ODBC 'Sample' files and I have three questions.<br><br>>> I am still not understanding the flow.<br>>><br>>> 1. In what filePro file do you put this link? New or do you use the <br>>> 'sample' files they came with fp?<br>>><br>>> 2. If it is a new file, do
you create a record for each table to<br>read?<br>>><br>>> 3. If it is only one link definition, do you "use" the appropriate <br>>> table in each processing?<br>>><br>>> As I said I'm just not getting the flow. Actually it just my age<br>(64).<br><br>> If you were to populate a filePro from from a CSV file via IMPORT<br>ASCII, how would you do it? The same answers apply to your 3 questions<br>above.<br>><br>>(Again, this is going under the assumption that you want to "import"<br>the file into filePro, rather than have live access to the SQL data.)<br>><br>>--<br>>Kenneth Brody<br><br>Ken,<br><br>That's my point exactly.<br><br>I use dif with import dif but it's the same. The link, tables and<br>fields are all defined in the dif file. There is no intermediate file<br>any longer.<br><br>So I assume (insert joke here) that I would define the link, table and<br>fields in the import
process. If that is correct then I just<br>misunderstood what the sample files show and all makes sense.<br><br>Thanks<br>Rick<br><br><br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br><br><br> </div> </div> </div></body></html>