Hi Craig,

One solution, AFAIK, is using ORACLE utilities for exporting/importing data via SQL PLUS (don't remember their names right now) and have the data you want in text format (delimited with ";" would be fine). Then you can import that
data to your Fox Table using APPEND FROM command. I don't know
if there exist an application that do this automatically, but
don't think so.

Also, if you have access to the UNIX machine from your Netware LAN you can use ODBC to connect to the ORACLE Database, but if the amount of data is large enough then you will have very seious performance troubbles. There is also a product from ORACLE (GLUE i guess) that can handle this connectivity, but you will need good buck$ to have it.

HTH,

J. Luis


>
>The raw data for this query comes in from the state and is stored on a unix box in an Oracle7 format (as far as I know)
>
>The data file for the FP app is stored on a PC Server running Netware.
>
>In order to stop our reliance on someone converting this data file and sending it here (we've gotten poor, late, and sometimes even no data from them), we'd like to find some sort of software package which could get this data from the Unix machine, format it for our FoxPro app, and store it on the NetWare server. We've downloaded Personal Oracle7 for '95, but it is cumbersome, confusing, and no one here knows how to work it right. Does anyone have any suggestions for a solution?
>
>-Craig