MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing email text into Excel database


Posted by Wendy Daniels on March 16, 2001 3:47 PM

We have created HTML/ASP web based forms that send text information to an email address. What we would like to do is allow our clients to easily transfer the received information to an Excel database without having to simply copy and paste each email. Any input on possible solutions, methods to try?


Posted by Mark W. on March 19, 2001 10:46 AM

Have you considered using Microsoft's Text ODBC
driver and Excel's Get External Data command?

Posted by Wendy Daniels on March 20, 2001 9:24 AM

Where can I get more information on this, Mark?

Posted by Mark W. on March 20, 2001 4:07 PM

Start with the Excel Help topic for "ODBC Drivers".