Have a fox based application on Unix SCO Open Server 5 and it would be great if I could work with the data in Access. I have heard of something called "data mining" with a data pump. Will this work between our version of Unix and Access? If so, is the data that "converts" into Access static or dynamic? Any other ways of accomplishing data conversion between Unix and Access? [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is data conversion from Unix to Access possible?
- Thread starter storer
- Start date
ElgisRamon
MIS
And that is static process... you will need to reexecute it whenever the data in the source change! [sig][/sig]
I don't know exactly what you mean by 'fox-based' application. However, there are several implementations of ODBC (Microsoft's Open Database Connectivity) for various Unix databases. MySQL, and PostgreSQL, for example each have third-party ODBC libraries. These allow you to run the database on Unix with the full power of the Unix system, but use Access as an occasional or continual front-end.
Look around, there might be an ODBC library for what you want to do. [sig][/sig]
Look around, there might be an ODBC library for what you want to do. [sig][/sig]
<grin>
he means foxBASE --- that's the old name for it..... You youngsters, I don't know...
Storer,
It's not compatability between "Unix" and Access you have to consider here -- between foxBASE on Unix and Access is the issue...
If you can't get an ODBC driver for foxBASE then you could try to do a periodic (daily maybe) transfer by setting up a cron job on the unix server that extracted the data into a text file or two and then transferred it to where the Access DB lives -- it could then be imported into the Access DB. [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href= Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. <grin>[/sig]
he means foxBASE --- that's the old name for it..... You youngsters, I don't know...
Storer,
It's not compatability between "Unix" and Access you have to consider here -- between foxBASE on Unix and Access is the issue...
If you can't get an ODBC driver for foxBASE then you could try to do a periodic (daily maybe) transfer by setting up a cron job on the unix server that extracted the data into a text file or two and then transferred it to where the Access DB lives -- it could then be imported into the Access DB. [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href= Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. <grin>[/sig]
- Status
Similar threads
- Locked
- Question