ECPTextStream VS msaccess-vcs-addin

The table below shows the overall performance for the read operations, you can download the test files from here. The test machine is running Win 10 Pro 64-bit, Intel® Core™ i7-4500U CPU N2600 @1.80 GHz - 2.40 GHz, 8 GB RAM.

This is a perfect use case for ECPTextStream. Create a loop for read the source text file and write the result file. Inside the file loop, manage to handle the last chunk of information and remove the last char until a line break is found.

Maybe the ECPTextStream class module can help you. This library is faster than the scripting method when dealing with text files and can manage files up to 2GB without any problem. See the benchmarks here.

Parse CSV/TSV through streams with the ECPTextStream class module.

New versión of the VBA-CSV Interface class. This will integrate the ECPTextStream class module in order to reduce memory overloads when retrieving few records from a CSV file.

I use Access VCS. You export the database, front end or back end to a folder and then add it to a git repo from there. It will not save the data only the code, macros, forms, reports, queries, and table schemas.

This is similar to what I was thinking of doing but was just curious if because of the way SharePoint works with the user directories if I could pop an update into the folder and it would resync with the new version whenever I may updates. If it doesn't indeed play well I've got a VBA script that checks to make sure the an FE file variable matches a table in the backend and if not prompts them to update to the newest version. I've also been using msaccess-vcs-integration and it's been a life saver.