Power Query Using VBA and Sql To Import Text File.

In this tutorial, you'll learn how to automate importing data that would normally be a drain on Excel's resources, using Power Query, VBA and SQL.
This will take your programming to the next level. This video covers ...
* Importing a 1.5 Million row text file to power query (file is too big for Excel to handle without Power Query).
* Changing Dates from text to date format and applying the CORRECT regional settings.
* Building a calculated column in Power Query.
* Explaining M code and editing it in the Power Query Advanced Editor.
* Explaining Business Rules Coding v Implementation coding, this is big and is a secret to writing great code.
* Using a simple class module to simplify and make your code more elegant..

☕
☕

Video Production
===============

Microphones
---------------

Video Kit
-------------
Lights

Note Taking
--------------

#ExcelVBA #PowerQuery

DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
If you do use one of the links, thanks I appreciate it.

[BusinessProgrammer]

Hey, Let me know in the comments below, what you'd like me to cover in my next video.

[umeshlangade]

Thank you so much Sean Johnson for this beautiful video :)

[zjason]

Thanks for sharing! Very helpful to deal with daily work!

[dunnobe]

I was wondering how you got the colours in the advanced editor? Pretty convenient and I don't know how to do that :(

[Raskolnikov]

Hi Sean, I downloaded the file and tried some of yours Queries but when applying count and sum, the result is always"Query failed"....what could be there problem?