Transfer MS Access Between 2 AMS Executables

[pakapaka]

Hi Guys
I hope I am not asking too much from the forum.

I have 2 AMS executables each one contains a datagrid component that retrieves data from an MS Access database. The databases are seperate for each project.

What I want to do is:
1) Open one of the AMS applications
2) Select several rows (or columns) of data using some kind of GUI and export the data. I would also like to show some kind of dialog box that shows the data is being exported eg. "Exporting Item 1....Exporting Item 12...etc).
3) Then I open the second AMS application. I click Import to update the second database with the selected data. I would also like to show some kind of dialog box that shows the data is being imported eg. "Importing Item 1....Importing Item 8...etc).
4) Click a Refresh Data button and display the imported data in the datagrid.

Is this possible and can anyone help me do this?
Perhaps someone has already done something similar
Thanks
Pakapaka

[Dermot]

Why not just open database 1 and 2 from the one app and insert the records directly. That would be way simpler.

[pakapaka]

Thanks Dermot
I am trying to "simulate" 2 existing applications (...not actually building a new one). So I need to stick with the flow described above.

Which commands would I use to Open the first database, select records and insert them into the second database?
Thanks
Pakapaka

[Dermot]

I wasn't suggesting combining 2 into one. I simply meant if you want to transfer data from one db to the other you could do it directly from one app without exporting it to a file and importing into the other app. If you are already connectting to one db then it is just as easy to connect to the second one and insert the records.

[pakapaka]

Oh I see what u mean. Which commands do I need to use?