OK I'm lost... DataBase help..

[puros_bran]

Is there a way with Open Office (or some other Open Source) to import data to a db via email?

ie: email comes in exchange with the data (Name, date, line 1= 4, line 2 = 8, line 3 = 8, line 4 = 4) and the data is automatically put into the database.

 

[sstodvictory]

CPAN has some modules that look good for this if you can script in Perl. In that case you could use the Perl DBI and appropriate DBD modules to populate whatever database you're working with. If you're using MS SQL Server its a little more complex to set up DB connectivity using Perl DBI, but it is possible with open source.

ie. see the top three hits here:
http://search.cpan.org/search?query=microsoft+exchange&mode=all

Steve