Monthly Archives: Jan 2021

Querying Text/CSV files in VBA, method #3: Power Query

Posted on Jan 19, 2021 by Patrick O'Beirne, Excel/VBA developer

The module PowerQueryText.bas contains VBA code to query text/csv/tab delimited files and return tables to worksheets. Continue reading →

Posted in Excel/VBA, Power Query | Tagged , , , | 3 Comments

Querying Text/CSV files. Method #2: ADO Recordset

Posted on Jan 18, 2021 by Patrick O'Beirne, Excel/VBA developer

The module ADOQueryText.bas has the functions to read a delimited text file into a worksheet. It uses an ADODB recordset to perform the query. Continue reading →

Posted in Excel/VBA | Tagged , , , , | Leave a comment

Querying Text/CSV files. Method #1: Querytable

Posted on Jan 13, 2021 by Patrick O'Beirne, Excel/VBA developer

The legacy Get Data from Text/CSV command in Excel creates a Querytable. This is pretty good for most purposes, except… Continue reading →

Posted in Excel/VBA | Tagged , , | Leave a comment

Reading Unicode file contents as text

Posted on Jan 12, 2021 by Patrick O'Beirne, Excel/VBA developer

This is a short update on my post of Sep 28, 2020 on reading Unicode text in VBA. I am reposting the module as ADOStream.bas Continue reading →

Posted in Excel/VBA | Tagged | Leave a comment

Hello (the rest of the) World – reading data in other languages

Posted on Jan 11, 2021 by Patrick O'Beirne, Excel/VBA developer

Have you ever opened a text file in Excel and found that the characters looked weird or corrupted? The Wikipedia entry for mojibake says ‘In German, Buchstabensalat (“letter salad”) is a common term for this phenomenon, and in Spanish, deformación … Continue reading →

Posted in Excel/VBA | Tagged , , , | Leave a comment