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!
Watch video Wise Owl Answers - How do I refer to a field name with a dot in ADODB? online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 09 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,170 once and liked it 51 people.