Hi,
I have a txt file (originally .dat file actually) I need to im****t into a
table in Access.
It has multiple records and each record is over several lines. Fields are
delimited by '|' and the end of each record is indicated by '@[EMAIL PROTECTED]
'. Apart
from
that there are carriage returns & spaces in some of the middle fields
(which
would be Memo fields) which need to be kept.
Eg:
1|xxx|a: cat
b:dog
c: mouse rat |date@[EMAIL PROTECTED]
above is 1 record with 4 fields. In a file there could be any number
of
records like this - not always the same number of lines per record.
Is there any way to im****t the records?? give an end of record
delimiter???
Thanks,
--
Kate P