Solved

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

Posted on 2013-01-23
2
174 Views
Last Modified: 2013-12-12
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
0
Comment
Question by:josyp
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38811956
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
 

Author Comment

by:josyp
ID: 38813130
Let me go through and will get back to you , thanks.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question