I receive e-mails from web form submissions and need to automatically
transfer the data into a Microsoft Access database. Can anyone suggest a
good product that would take the data from the e-mails and either save it
to a file (comma or tab delimited) for later importing into Access or write
the data directly to Access?
Thanks.
This is a MIME GnuPG-signed message. If you see this text, it means that
your E-mail or Usenet software does not support MIME signed messages.
--=_mimegpg-commodore.email-scan.com-25623-1120947730-0002
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
DN writes:
> I receive e-mails from web form submissions and need to automatically
> transfer the data into a Microsoft Access database. Can anyone suggest a
> good product that would take the data from the e-mails and either save it
> to a file (comma or tab delimited) for later importing into Access or write
> the data directly to Access?
This is a highly specialized situation; it's possible, but highly doubtful,
that there might be a commercial product that does something like that. And
the realm of free software won't help you either. On Linux or Unix normally
it should not take more than an hour, or so, to set up an E-mail address
that runs a Perl script that swallows up E-mail and automatically uploads it
to MySQL or PostgreSQL. Even though there's a Windows port of Perl, because
both your E-mail client and Access are closed commercial products, the
chances of getting free software tools to interoperate with them are zero.
--=_mimegpg-commodore.email-scan.com-25623-1120947730-0002
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQBC0E4Sx9p3GYHlUOIRAm9IAJ4u3AoCyBOy4hdep/PWI3NaIUAi7QCf SNAt
uStKT+6x8Ii6y9WiCGgsmpA=
=8Eex
-----END PGP SIGNATURE-----
--=_mimegpg-commodore.email-scan.com-25623-1120947730-0002--
What is the product you use to receive e/mails ?
"DN"
Xns968EB5CAA612Adndndn2dninvalid@216.196.97.131...
>I receive e-mails from web form submissions and need to automatically
> transfer the data into a Microsoft Access database. Can anyone suggest a
> good product that would take the data from the e-mails and either save it
> to a file (comma or tab delimited) for later importing into Access or
> write
> the data directly to Access?
>
> Thanks.
In article
DN
> I receive e-mails from web form submissions and need to automatically
> transfer the data into a Microsoft Access database. Can anyone suggest a
> good product that would take the data from the e-mails and either save it
> to a file (comma or tab delimited) for later importing into Access or write
> the data directly to Access?
>
> Thanks.
See link to Inbox Organizer at: http://www.emailman.com/conversion
-Andrew
--
Andrew Starr
eMailman(r): http://www.emailman.com
NewsReaders(sm): http://www.newsreaders.com
Both of the above now have forums (newsreader or web access)!
"Macallan"
news:2M6Ae.1574$M04.1245@news.chello.at:
> What is the product you use to receive e/mails ?
Netscape 7 with an IMAP mailbox but I could switch to another Windows
client if necessary.
> "DN"
> Xns968EB5CAA612Adndndn2dninvalid@216.196.97.131...
>>I receive e-mails from web form submissions and need to automatically
>> transfer the data into a Microsoft Access database. Can anyone
>> suggest a good product that would take the data from the e-mails and
>> either save it to a file (comma or tab delimited) for later importing
>> into Access or write
>> the data directly to Access?
If you have a MAPI compliant mail client then you could probably read
through the mailbox with VBScript and extract the information you want from
the messages.
--
Andrew Butchart
andrew@floatingbear.ca
"DN"
news:Xns968F71D5C689Adndndn2dninvalid@216.196.97.131...
> "Macallan"
> news:2M6Ae.1574$M04.1245@news.chello.at:
>
> > What is the product you use to receive e/mails ?
>
> Netscape 7 with an IMAP mailbox but I could switch to another Windows
> client if necessary.
>
>
> > "DN"
> > Xns968EB5CAA612Adndndn2dninvalid@216.196.97.131...
> >>I receive e-mails from web form submissions and need to automatically
> >> transfer the data into a Microsoft Access database. Can anyone
> >> suggest a good product that would take the data from the e-mails and
> >> either save it to a file (comma or tab delimited) for later importing
> >> into Access or write
> >> the data directly to Access?
On 9-Jul-2005, Sam
> > I receive e-mails from web form submissions and need to automatically
> > transfer the data into a Microsoft Access database. Can anyone suggest a
> >
> > good product that would take the data from the e-mails and either save
> > it
> > to a file (comma or tab delimited) for later importing into Access or
> > write
> > the data directly to Access?
>
> This is a highly specialized situation; it's possible, but highly
> doubtful,
> that there might be a commercial product that does something like that.
> And
> the realm of free software won't help you either. On Linux or Unix
> normally
> it should not take more than an hour, or so, to set up an E-mail address
> that runs a Perl script that swallows up E-mail and automatically uploads
> it
> to MySQL or PostgreSQL. Even though there's a Windows port of Perl,
> because
> both your E-mail client and Access are closed commercial products, the
> chances of getting free software tools to interoperate with them are zero.
Look into ParseRat (www.guysoftware.com), or search for the term "file
parser."
--
Warmest regards,
Steve Horrillo, Realtor / C.Ht.
http://BrokerAgentTraining.com http://over100percent.com http://HipFSBO.com
http://eLOWn.com