Append and upload data from Multiple Excel sheets

dspa0712

New Member
Joined
May 4, 2007
Messages
31
I have created an Access Database with Table called "data" and fields Names......

Provider
Service Name
Service Number
Primary Client Group
Capacity
Service Type
FTE Managers
FTE Staff

In the location
S:\Team\Contracting\Supporting People\Finance Monitoring\New Costing\Data

I have saved numerous excel spreadsheets all with different file names but with same structure.

On each individual spreadsheet in this location is a Worksheet name "master"

I want a msgBox to pop up in access asking "Do you want to upload new data?"

If the result of the question is Yes then the results of all the master sheets in the named location to be appended to the Access Table called "data"
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,181,374
Messages
5,929,577
Members
436,680
Latest member
kellyjkon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top