Forum Discussion
Transfer of worksheet data to a MS Access database for later analysis
If I am in the wrong area/group here, just tell me. Signed up this morning! I am no 'techy' on computers, so I could do with some assistance. It is eleven years since I last set worked intensively ...
Hi Grant, linking between Access and Excel is still possible, as is creating user friendly interfaces in Access to avoid the need to link
Also with the advent of Power Query it is relatively straightforward to consolidate multiple Excel templates into a single Excel Table.
Lots of options available
Also with the advent of Power Query it is relatively straightforward to consolidate multiple Excel templates into a single Excel Table.
Lots of options available