Hi there,
I'm newbie to the data model/power query so I'm sorry if this question turns to have a rather simple solution.
I'm working with daily Access files (for saving data for each date due to size limitations, I know I should move to SQL-Server sometime), e.g: 01-12-20.accdb, 02-12-20.accdb, 03-12-20.accdb and so on.
Can I update the data model with those file, meaning if I want to compare data between changing dates, Could I do it programmatically (using VBA or something like that)?
Thanks,
Udi
I'm newbie to the data model/power query so I'm sorry if this question turns to have a rather simple solution.
I'm working with daily Access files (for saving data for each date due to size limitations, I know I should move to SQL-Server sometime), e.g: 01-12-20.accdb, 02-12-20.accdb, 03-12-20.accdb and so on.
Can I update the data model with those file, meaning if I want to compare data between changing dates, Could I do it programmatically (using VBA or something like that)?
Thanks,
Udi
