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.