Tag Archives: CSV

Power Query infer data types with Table.Profile

Posted on Oct 28, 2021 by Patrick O'Beirne, Excel/VBA developer

The Power Query UI automatically detects column data types and performs the transformations for you. Typically these steps look like this: However, when I am calling Power Query M code from VBA ( see my previous posts) to open any … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Excel Virtually Global 2021

Posted on Oct 8, 2021 by Patrick O'Beirne, Excel/VBA developer

I am one of the 48 speakers at a 48-hour Excel extravaganza online on Oct 12 and 13. It’s FREE but you are encouraged to make a donation to charity to reflect the value to you of the content you … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

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