Wise Owl Answers - How do I refer to a field name with a dot in ADODB?
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Check out our other answers here • Wise Owl Answers
Get files here https://www.wiseowl.co.uk/vba-macros/...
This video explains what to do if your Excel column name contains a dot and you need to reference it in an SQL query using ADODB. As an added bonus you'll also learn how to deal with exclamation mark characters!
Chapters
00:00 The Question
01:24 Why a Dot in a Field Name is a Problem
02:41 Replacing Dots in Field Names
03:45 Replacing Exclamation Marks in Column Names
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
Смотрите видео Wise Owl Answers - How do I refer to a field name with a dot in ADODB? онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WiseOwlTutorials 09 Август 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,170 раз и оно понравилось 51 людям.