How to automate MS Access program to import data from different database?

I am not a vb expert so I need your help in solving this. Please see attached word document and MS Access program for requirement. MS Access version is 2010.
Summary-of-the-requirement.docx
PGMCONSOLE.accdb
josypAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

The link above shows how to store and retrieve connection information, and how to create DAO table links.

Once you've done this, you can then "import" data from those linked tables like this:

Currentdb.Execute "SELECT * INTO MyLocalTable FROM MyLinkedTable"

Note that "MyLocalTable" cannot exist. If it does, you'll get an error, so if you need to remove the table first,  run this:

Currentdb.Execute "DROP TABLE MyLocalTable"

Then run the SELECT INTO statement.
0
 
josypAuthor Commented:
Let me go through and will get back to you , thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.