Question: Hello, I am creating an access database and need a macro to do the following: Open an excel file it is a linked file, so

Hello, I am creating an access database and need a macro to do the following:
Open an excel file
it is a linked file, so it needs to be opened refresh the data.
After data has been refreshed, data from 2 sheets needs to be imported into two seperate tables. the existing data needs to be overwritten.
Excel file needs to be closed after data has been refreshed and imprted.
Thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Consider the following scenario: chris and pat aquino own a successful isp (internet service provider) and want to expand their business to host an internet auction site. the auction site will let...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

EX16_AC_CH02_GRADER_CAP_AS - Metropolitan Zoo Project Description: The Metropolitan Zoo tracks its animals in Excel. The organization decides to use a database to organize the data about the animals,...

Q:

I am needing assistance on this assignment. I have started it but I am stuck at the total page (the fourth sheet under the bullet #1). I know I am probably making this way harder than it needs to be...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Q:

BA630 - Systems Analysis & Design Exercise (Team Project) Maximum Word Count: 4000 words The purpose of this project is to pull several ideas together that we have covered throughout the semester and...

Q:

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Q:

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Q:

Polar Express, Inc., is considering a project that will result in initial aftertax cash savings of $4.5 million at the end of the first year, and these savings will grow at a rate of 4 percent per...

Q:

Beverly Plastics produces a part used in precision machining. The part is produced in two departments: Mixing and Refining. The raw material is introduced into the process in the Mixing Department....

Q:

A 1 8 - year loan requires month - end payments of $ 6 6 2 . 3 3 including interest at 9 . 9 % compounded monthly. What is the balance on the loan after half of the payments have been made? ( Do not...

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

A Is it crucial that an employer know how long it took you to earn your B.A.? Is it unethical to simply note the date you finished it?

Q:

3. A member of a group you belong to suggests that everyone contribute $50 for a wedding present for another member. A. Wow, thats pretty generous! B. What specifically are we going to buy? C. Im...

Q:

4. Youre asked to give a speech about your athletic success to a high school sports team. A. Im no good at that sort of thing. B. What goal do you have in mind? C. I cant commit to speaking this fall.