Please help - Import Macro

[MITSupport]

Hi all,

Thanks in advance for reading this question:

I have been trying to import data from a workbook with multiple spreadsheets into my front end database which is connected to a Web app back end (Access Web App) on SharePoint (Office 365).:banghead:

All the tables are linked and there are Read/Write Permissions on the web app and I need to be able to do the import manually. If this is possible how can i get a macro or module etc (I don't know what to use) to automate this.

The first picture is the database table design:
The Second image is the names of the cells containing the data in the Excel Spreadsheet (Which is coincidentally also matching with the Table design. If this is wrong please let me know)
The third image is the spreadsheet names which needs to go into the table as the Classification. (I have created a separate table and linked them together on the Web App with the Classifications in it. Again if this wrong please let me know)

The hard part for me is writing the macro/module or whatever I need as i dont know enough about macros and modules. I have been beating my head against a wall for long enough and i really need help (yes probably mental for accepting this job lol)

If you can help please tell me the best way to go about it and in a a dumbed down version even though i work in IT i still cant catch up with Access as it has been way too long since i have done any programming

I am also willing to pay for help as well.

Thanks again

MITSupport

 

[Ranman256]

I would have a download button, to copy the excel file to a folder,to the same name everytime. File2import.xls.

In Access, link each worksheet as a table.
Make a query to append each table to the master table.
Put all queries in a macro.

Then the steps will be:
1.Download new excel file
2. Run macro
Done.

 

[MITSupport]

Thank you for your advice Ranman

but how exactly would i do that? I have been trying and it is all failing and i am lost. I dont even know where to start the Macro or the query.

Please can you give me some dumbed down instructions to make the macro please.

TIA

MITSupport