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"
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"
