Good day all, I am hoping someone can shine the light on my mistakes.
I have an ADO code the runs in excel pulling info from an MS access DB.
The issue is when I pull FROM a table that has one word it works fine but if the table has more than one word with a space etc it does not work.
If i replace the "Profiles 3-4" below with one word like "Helmet" it works but i have so many tables in my DB renaming all to a single word is not realistic. Any help would be apprecited.
BTW im not new to excel VBA but access i am ver much a novice.
This is the selection of code where it errors:
Set Recordset = New ADODB.Recordset With Recordset ' Filter Src = "SELECT * FROM Profiles 3-4 WHERE BDE = 'HBCT' "Formatting tags added by mark007