Load Multiple Ms Access Files

[#1]

Hi All,

Can we load multiple Ms Access files with one connection from one folder like we do excel files, for example ?

Thanks and BR,

SAK

[#2]

I don't think you can. You can however create a loop for all Access files.

Within the loop you can change the connection to the file path of the current file.

I use this method in a Qlikview app to analyse lots of MS Access databases