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..
Power Query Reference with reviews US: https://amzn.to/2VISLk4
VBA Reference with reviews US: https://amzn.to/39Cwmd9
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
---------------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#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.
