Suggestions For Regular Data Extract (large Files)

dear all

i’ve been asked at work to pull two reports twice a month and join certain columns to make a master spreadhseet. each pull of the spreadhseet will be about 150k rows

with every report pulled, we have to append it onto the previous data set in order to track the changes so we can report at different stages

my manager has recommended MS access, however, i am trying it and having serious issues. we would also want to export the data at times to excel when needed

i am slightly technical and can learn with chatgpt but this will have to be accessible for my team, can anyone please recommend the best and easiest way?

submitted by /u/SoundDowntown5285
[link] [comments]

Leave a Reply

Your email address will not be published. Required fields are marked *