Скачать с ютуб 4. VBA - Create SQL WHERE Clauses (Series 1) в хорошем качестве

4. VBA - Create SQL WHERE Clauses (Series 1)

Academy 201 - Advanced VBA Series 1 Create SQL WHERE Clauses In this video, we make a concatenated list from data in a file and create where clauses of a valid SQL statement. This includes commas, equal signs, parenthesis, ANDs and ORs where needed. We use the Microsoft date part function to split a date into months, days and years for databases that store dates this way. **Special note: A correction has been made in the github files to change 'where Statement' to 'where clause" All the course material can be found on GitHub, including additional challenges and their possible solutions. https://github.com/Academy-201/Advanc... Join the Academy201BeyondTheBasics Facebook group for further discussions.   / 164824344744382   Like the Academy201BeyondTheBasics page to get updates!   / academy201beyondthebasics   If you have questions about any of the course material, you send an email to [email protected] #excel #vba #sql