I am in the process of developing an application using Access 2000. I have not been able to find anything on what I want to do. My question is I have setup a switchboard to access reports and forms, I want to have a botton which would do the following items (behind the scenes)

1) execute a predefined Crystal Report which will
Prompt the user for a date range of the items
Which need to be selected
2) Take the data from the report and do an export
To a text file
3) Import the text file into a access database and
Add the records into the database (I already
Have setup Import/Export Specs), I also need to
Know how to make sure that the data show up
As fixed width so that my specs will work.

Silly question, why call CR from Access, it has decent reporting built in. You can do what your talking to, how much coding do you want to do?