Unanswered: ADODB - Data Source Contains Apostrophe
I wrote some code that populates a table with a full path of thousands of Excel files. I'm then using these paths in connection string using ADO. I am reading the data from the various sheets and storing the data in another table. My problem is that a number of the Excel file names include apostrophe's or even a double quote to signify inches. As long as the program doesn't run into one of these files my code works great.
How do I resolve this? Do I need to parse the string by locating the single and or double quotes and replace them with something? Any ideas other than changing all the file names to not include them (not really an option)?