Export qry results to another database

[Guest]

In my office I run 2 databases (same design but different data). I would like
to be able to export a recordset to the other database or to a format that
the other user can import from. I know I can copy the datasheet toa new excel
sheet then email it for the the other person to copy and paste into there
table. Is there a better way to do this or automate this. Also: this
recordset belongs to related parent table and I would like if possible to
send the parent record and its related details record.
Thanks, Ed

 

[Guest]

Is the client requesting the results directly connected to your server?

If so the best way is to make a table and then use that table and delete it
when they are finished.

Just creater the queries and execute then from a form event.

Just link to the Tables you want the original data from.

If it is over the Internet than it is a lot more difficult but I have done
it.