I have 2 access databases that I need to share data between. In DB1 I need to export data. I have created a query that will get me the data that I need to export. Is there a way to do this automatically like in SQL Server's DTS packages or can I create a button that will fire off the export process?
In DB2 I need to import that data. I have the same question as above, can I do it through an automated process or button click?
How do I do either of these tasks.
Thanks.
In DB2 I need to import that data. I have the same question as above, can I do it through an automated process or button click?
How do I do either of these tasks.
Thanks.