ws-garcia/VBA-CSV-interface is an open source project licensed under GNU General Public License v3.0 only which is an OSI approved license.
Similar projects and alternatives to VBA-CSV-interface based on common topics and language
VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Scout APM - Leading-edge performance monitoring starting at $39/month. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
A geographic toolkit/library for VBA, excel etc.
Fast reading of delimited files
Go library for parsing and deserialising CSV files into Go objects
A CSV reading/writing application for Elixir.
Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)
reddit.com/r/vba | 2021-04-20
Working from Notepad++ gave me an idea of how the text strings should be manipulated from VBA. The first thing to do from the VBA CSV interface will be to import only the fields that contain the relevant data to solve the problem (the_geom and NAME). The files created in this step (temporary) will be saved in the same folder.
Around 1 GB .csv file in excel: I know what Column(s) I need, how do I proceed?
reddit.com/r/excel | 2021-04-11
You can use the VBA CSV interface in a smart way. The first step would be to create a new CSV with only the desired columns, then you can filter the information or subset the created CSV data into individual pieces of meaningful information. In my test, an input file with 12 columns (191 MB) is converted to a 4-column CSV (68.9 MB) and only European sales are retrieved from this file. The good news is that there is only 2 MB of data in memory when creating the 4-column CSV. Here is the file used in my test, set to C:\csv's\ folder to run the test on your own. Here is a clip showing the code in action.
Power query interprets comma in data as a separator erroneously
reddit.com/r/excel | 2021-03-31
Download this, follow this installation instructions add a new "normal" module an paste this code
Taking VBA to a new level when working with CSV files. Data subsetting.
reddit.com/r/vba | 2021-03-30
That mishap left me inoperative for a few days, until I decided to design a solution for the problem using VBA CSV interface, a tool much easier to program using code.
Parsing special text files from VBA
reddit.com/r/excel | 2021-03-19
u/cteno4, if you are reading this, you will be surprised to learn that you DO NOT NEED TO BROWSE THE WHOLE INTERNET to find a library that fits your needs. You can solve your problem with a few lines of code if you use VBA CSV interface.
Can Power Query's simple INNER JOIN CSV query be faster? [EXCEL]
reddit.com/r/vba | 2021-03-19
On the one hand there is a recorded macro to execute two queries and perform an operation similar to SQL INNER JOIN. The macro also sorts the result in ascending order in the "Country" field. The other contender is a procedure that will perform the same operations using the VBA-CSV interface* library.
Querying CSV in a like SQL way from VBA
reddit.com/r/excel | 2021-03-18
This can be great! here you can download some CSV samples.
Querying CSV in a like SQL way from VBA [Excel]
reddit.com/r/vba | 2021-03-18
Before starting to work on the VBA-CSV interface project, I did some research on the different problems that a standard Excel user could face when dealing with CSV files. At that time the project was just taking its first steps, having limited functionality and strictly adhering to specifications.
reddit.com/r/backtickbot | 2021-03-16
Use VBA CSV interface. With that library you can mark lines as a comment. So you can have a CSV file like:
[Microsoft Access] Dump CSV data to DAO table
reddit.com/r/vba | 2021-03-11
As many in this great community know, I have paid quite a lot of attention to the topic of importing CSV files from VBA. The latter motivated me to introduce to the VBA CSV interface project a new module that allows programmers to work with CSV files from Microsoft Access.
VBA CSV Interface v3 Pre-release
reddit.com/r/vba | 2021-03-01
I am so excited to introduce to this great community the Pre-release v3 of the VBA CSV Interface library. The new version involved the complete rewrite of the v2.0.4 class module, due to the huge variety of options offered by the latest version:
What have you been working on? (Week of January 15, 2021)
reddit.com/r/vba | 2021-01-14
This module can help you to achieve your goals treating CSV files.