Pull data from various files..

[sanket_sk]

Hi All,

Hope you are safe and sound.

This is Sanket recently stared working on Microsoft Access 365, learning functions and solutions.

I have huge data breaks in quarterly files in excel format coming from year 2015 and continue, often I have to pull data from various years some times more than one quarter data we need.

Currently I create new excel, copy data from various files and prepare new file as per requirement.

I kept all quarterly files in particular folder, I have created user form / query where I can put date rage and various criteria for data i need.

Now my question is, is there any way by which I can link files from particular folder and access will pull the data whenever required as per input given in form / query.

Thanks & Regards
Sanket

 

[alansidman]

Look at Power Query for a means to consolidate files.