Sending 2 tables to get ONE excel sheet OR 1 Acc' table

[cuok]

We decided to put this Q. in this forum too (beside “Modules forum”) because the unclear subject we put there and we hope it’s not making problems.

Maybe this mission is not possible but it is a bit frustrating us so we must ask first:

My wife and me are working on 2 computers with same Access Program so we have identical structure Access tables but not same pupils (7 tables on each comp.).

From time to time (2-3 weeks) we need to combine the identical tables from the 2 computers, to one table.

What we used to do (till now!) was to send the table by e-mail from computer A to computer B using this command:

DoCmd.SendObject acSendTable, "TblMarksCourseD", acFormatXLS, "our@e-mail ", , , _
"Current Spreadsheet of Biochemistry", , False

Then we exported the “TblMarksCourseD” table from computer B to itself as excel sheet. Then combined the 2 tables to 1 by “copy and paste”. After this action we have a union excel sheet made of "TblMarksCourseD” from computer A and “TblMarksCourseD” from computer B


Then we repeat this action to all other tables and at last we have 7 sheets made of all 14 tables.

Is someone there can simplify what we are doing?

To be more clearer (we hope):

We need an automatic way to send to same e-mail 2 identical tables (by structure not PK) and to get them as ONE combined excel sheet !!


Thank you ALL in advance and for any help or hint

CUOK

 

[Darrylles]

Hi,

It really sounds like you have the same tables on 2 seperate computers and need to consolidate these at intervals.

Sounds like you need a simple, cheap, peer to peer network (£20 in UK max).

Also, a slight change to how you use your database(s).
(There is no need to copy data as you do).

Both computers use ONE database which is on only on ONE computer.

The consolidated database also sits on one computer and is automatically updated as each student progresses. You never need to copy data at all.

Please post your comments to this Cuok (I may have it totally wrong).

Kind regards,

Darrylles


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[cuok]

Hi dear Darrylles !

Do you mean that we can “Both computers use ONE database which is on only on ONE computer”

Also
we have to admit that you 100% right we “ have the same tables on 2 separate computers and need to consolidate these at intervals.”

Physically we can’t connect the computers! my “work room” is something like a warehouse behind the house!!

Does your idea still exist?

We are ready to buy\pay for solving our problem!

Thanks a lot and we are waiting with no patient to hear from you!!

CUOK

NB. Our email: cuok@bezeqint.net

 

[PWise]

after you email the table from 1 computer to the other link the file to access and create a union query
select * from histable
union select * from hertable