Creating a DB export into a text file

Hi there,



I have a website which runs on an MS Access database, and is constantly updating via online web pages, udates are never done offline.



Basically what I need to do is output certain tables of records into a txt file which is then to be sent to another website so they may include my records on their database via a simple import.



I have done this by downloading the db, going into MS Access and exporting this manually. Is there anyway I can code something in ASP to create this txt file for me on the fly and then I can send this via email again behind the scenes all with a click of the button. Saving any kind of manual download of the database, then manual export and then manually emailing this?



The reason being is I may find this easy, but another user may not and I would love to be able to automate this in some way.



Many thanks for your help as always

assuming you have some familiarity with ASP this would be a half decent tutorial:



http://www.learnasp.com/learn/txtwrite.asp



As for email... not sure how to attach a file.



Cheers,



Dean