Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2008

Tip: Looking for answers? Try searching our database.

Import text into one field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy - 05 Feb 2008 15:57 GMT
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!!
Larry Daugherty - 05 Feb 2008 18:24 GMT
One way is to use File/IO: using your synchronizing logic, Line Input
and store to YourField in YourTable.

HTH
Signature

-Larry-
--

> Hi
> I am trying to create a file of orders received by email. I've got a program
[quoted text clipped - 19 lines]
>
> Thanks!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.