Glad to see you have not given up.
The connection string is not telling me anything so far.
Since we never encountered an error on the line
before now, what has changed?
Is the sheet with the pivot table no longer the active sheet? We probably should change that anyway. Make it more like:
Good to test DocDate. The time stamp should not be a problem (the db I am using for testing on my end also has time stamp), as long as the field is defined (in Access) as Date/Time. We only have an issue if it appears to be a date, but is really text.
It appears from the code you posted this morning that after trying double quotes, you attempted to go back to what you had before, but did not succeed. Note the difference between this character ' and this character `
You should be able to use double quotes "" or whatever you call this `. But, you CANNOT use '
Don't ask me why. It is neither an Excel thing, nor an Access thing. It is an ODBC thing.
If we don't crack this from Excel in the next iteration or two, I really want to test the SQL in Access directly. How facile are you with Access?
Bookmarks