<div>
Thanks SidFishes, I had tried using cfpop for about 2 hours trying to get it to work, but the second link to the likedocs was exactly what I needed. <br />
<br />
Thanks again!
</div>


<div>
You can save the files into text/csv format and load them into MySQL using LOAD DATA INFILE MySQL database command.
</div>


<div>
<div class="content wysiwyg-content">
Hello, <br />
I'm not 100% sure this is possible but I'll throw it out there in hopes that it is. <br />
<br />
I have reports that get sent to me weekly with various data that needs to be placed into a MySQL database. What I am interested in doing is having some type of script pull these email messages from the pop server and place the data into the MySQL database. <br />
<br />
If anyone has any idea how to do this I'd be very thankful, as it would save me massive work of retyping all the data.<br />
<br />
Thanks!<br />
<br />
-Jordan
</div>
</div>


Hello, 
I'm not 100% sure this is possible but I'll throw it out there in hopes that it is. 

I have reports that get sent to me weekly with various data that needs to be placed into a MySQL database. What I am interested in doing is having some type of script pull these email messages from the pop server and place the data into the MySQL database. 

If anyone has any idea how to do this I'd be very thankful, as it would save me massive work of retyping all the data.

Thanks!

-Jordan

Thanks SidFishes, I had tried using cfpop for about 2 hours trying to get it to work, but the second link to the likedocs was exactly what I needed. 

Thanks again!

You can save the files into text/csv format and load them into MySQL using LOAD DATA INFILE MySQL database command.

How to import email messages into MySQL

Hello, 
I&#39;m not 100% sure this is possible but I&#39;ll throw it out there in hopes that it is. 

I have reports that get sent to me weekly with various data that needs to be placed into a MySQL database. What I am interested in doing is having some type of script pull these email messages from the pop server and place the data into the MySQL database. 

If anyone has any idea how to do this I&#39;d be very thankful, as it would save me massive work of retyping all the data.

Thanks!

-Jordan

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.