FM - Using ODBC
Posted on 2011-02-22
I'm looking into FM's ODBC connections, but without any luck. I've read all the FM help on ODBC. I haven't done this for 7 years since I used access, but I remember it being much easier (just a couple of clicks and settings). To clarify, we only import tab or Excel files exported from a DOS database. However, I read somewhere that ODBC can be used for flat files such as tab delimited or Excel. However, when I try, it asks for an ODBC driver and none are listed (on the host). Do I have to load some drivers on the server? There aren't any built in for tab or Excel files?