Talk About Network

Google





Software > Access External data > Im****t txt fil...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 11287 of 11376
Post > Topic >>

Im****t txt file - records on multiple lines

by =?Utf-8?B?S2F0ZSBQ?= <KateP@[EMAIL PROTECTED] > Nov 24, 2008 at 08:36 PM

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
 




 2 Posts in Topic:
Import txt file - records on multiple lines
=?Utf-8?B?S2F0ZSBQ?= <  2008-11-24 20:36:10 
Re: Import txt file - records on multiple lines
"Scott Lichtenberg&q  2008-11-25 10:45:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 0:07:59 PST 2009.