Export qry results to another database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top