Hi,

We have a problem like this: There is a text file containg data on a conversation done by Forex dealers. We want to store this in an Oracle table and and display using Oracle Forms. I tried using OLE db, ACtive X as the data type for the filed but it did not work. Would be very greatful for any suggestions.

Regards,
Francis.

This is what the conversation looks like:

<STX><FS>340<US>AA<GS>CENS#9240C<US>504<US>0<RS>54 8<US>TO CENS CENTRAL BK SRI LANKA * 0959GMT 030903 */1738 CNV
Our terminal : CENS Our user : NWGRD Nanayakkara
# RAJA> DLR/YEN FOR ONE PL
VEDITHRI> 09/17
# SELL DLRS
TO CONFIRM 1 MIO AGREED AT 116.09 I BUY USD
# MY YEN TO BTM TOKYO AC NO 0012500354 PL
MY USD TO FED RESERVE NY, NEW YORK
# AGREED

# #INTERRUPT#
#
#INTERRUPT#

#END REMOTE#
^ ##ENDED AT 10:01 GMT##
^ ## TKT EDIT OF CNV 1738 BY DN 1001GMT 03SEP2003
^ STATUS CONFIRMED
^ ##ENDED AT 10:01 GMT##

( 52 CHARS)





<FS><ETX>>