I have several excel spreadsheets on several different computers and one Access database on a network drive. Each spreadsheet has a macro that sorts raw data into a single table with column titles. I have very little knowledge of Access or even creating SQLs, but I do work with Macros in excel frequently.
How can I link my excel data to an already existing table in access?
The excel data is already sorted to match the headers in Access.
The data needs to be placed beneath the existing data in Access.
Note that data is not stored in the excel sheets, rather it is cleared out when the macro is ran again for another set of data.
Is there a way to write in vba to automatically dump this data into my Access table named "Access QC Database"?
The file path for the Access database is Q:\Access QC Database.accdb.
The tab title in excel that has the data is called "DB"
If possible, I would like to avoid any prompts from popping up, like Yes or NO options, due to the amount of times that the macro has to be ran. Basically press the macro button and that's it.
I would greatly appreciate any help on this matter because I have been searching the internet for quiet some time trying figure this out.
How can I link my excel data to an already existing table in access?
The excel data is already sorted to match the headers in Access.
The data needs to be placed beneath the existing data in Access.
Note that data is not stored in the excel sheets, rather it is cleared out when the macro is ran again for another set of data.
Is there a way to write in vba to automatically dump this data into my Access table named "Access QC Database"?
The file path for the Access database is Q:\Access QC Database.accdb.
The tab title in excel that has the data is called "DB"
If possible, I would like to avoid any prompts from popping up, like Yes or NO options, due to the amount of times that the macro has to be ran. Basically press the macro button and that's it.
I would greatly appreciate any help on this matter because I have been searching the internet for quiet some time trying figure this out.
