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!!
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!!