{"id":40080,"date":"2026-04-01T12:37:41","date_gmt":"2026-04-01T10:37:41","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/suggestions-for-regular-data-extract-large-files\/"},"modified":"2026-04-01T12:37:41","modified_gmt":"2026-04-01T10:37:41","slug":"suggestions-for-regular-data-extract-large-files","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/suggestions-for-regular-data-extract-large-files\/","title":{"rendered":"Suggestions For Regular Data Extract (large Files)"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>dear all<\/p>\n<p>i&#8217;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<\/p>\n<p>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<\/p>\n<p>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<\/p>\n<p>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?<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/SoundDowntown5285\"> \/u\/SoundDowntown5285 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1s9gbkg\/suggestions_for_regular_data_extract_large_files\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1s9gbkg\/suggestions_for_regular_data_extract_large_files\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-40080 jlk' href='javascript:void(0)' data-task='like' data-post_id='40080' data-nonce='9941108d62' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-40080 lc'>0<\/span><\/a><\/div><\/div> <div class='status-40080 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>dear all i&#8217;ve been asked at work to pull two reports twice a month and join certain&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-40080","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=40080"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40080\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=40080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=40080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=40080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}