Import text into one field

G

Guest

Hi
I am trying to create a file of orders received by email. I've got a program
that strips out the text of an email and stores it in csv format. When I try
to import that into Access, it creates separate records for each bit - ie
when the line ends (carriage return or line feed). For me to be able to
extract the bits I want, the information would have to go into one record.
Is there a way of importing a csv file into a single field?
A sample of the data is below:

This is a multi-part message in MIME format.

--_=DotNetOpenMail=_jin13rni3k0qqygzufot33hwetgohecl1h1v

Content-Type: text/plain;

charset='iso-8859-1'

Content-Transfer-Encoding: quoted-printable



Each of these 'lines' go into new records - but I need them all in one
record.

Thanks!!
 
L

Larry Daugherty

One way is to use File/IO: using your synchronizing logic, Line Input
and store to YourField in YourTable.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top