Stats

Basic VBA-CSV-interface repo stats
12
12
9.1
17 days ago

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.

VBA-CSV-interface Alternatives

Similar projects and alternatives to VBA-CSV-interface based on common topics and language

  • GitHub repo stdVBA

    VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.

  • GitHub repo ECPTextStream

    ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.

  • GitHub repo QueryCsvToExcel

    Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel

  • GitHub repo geo_vba

    A geographic toolkit/library for VBA, excel etc.

  • GitHub repo vroom

    Fast reading of delimited files

  • GitHub repo csvdecoder

    Go library for parsing and deserialising CSV files into Go objects

  • GitHub repo csvlixir

    A CSV reading/writing application for Elixir.

NOTE: The number of mentions on this list indicates mentions on common posts. Hence, a higher number means a better VBA-CSV-interface alternative or higher similarity.

Posts

Posts where VBA-CSV-interface has been mentioned. We have used some of these posts to build our list of alternatives and similar projects - the last one was on 2021-04-20.
  • 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.
  • https://np.reddit.com/r/excel/comments/lxjl77/importing_a_csv_with_2_tables_using_vba/gr6zmsh/
    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.