|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
August 28th, 2003, 01:12 PM
|
|||
|
|||
populate Access DB with 1000 emails
I just came to work for an organization that had the results of a survey sent to an email address. There are about 1000 emails that they want to organize and collect data from.
Is there anyway to forward all 1000 emails into an Access database? I'm definitely going to rewrite the survey form to do this for next year, but I was hoping someone might have some good information on manipulating this years data. Thanks for the help.
|
|
#2
August 28th, 2003, 01:19 PM
|
||||
|
||||
|
To get meaningful information into the database (besides just the blob of the email) you will have to write a parsing program. It _could_ be done in SQL, but you are better off looking at something else (Perl, VB, even C/C++). Next year, suggest to your organization that you send the survey as a URL to a web page where you can use CGI to load it directly into a database.
__________________
Left DevShed May 28, 2005. Reason: Unresponsive administrators. Free code: http://sol-biotech.com/code/. Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html. Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html. It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it. --Me, I just made it up The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man. --George Bernard Shaw
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > populate Access DB with 1000 emails |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
