I am facing this error when I am porting data from SQL recordset to a excel file suing Microsoft jet ole db provider.
Microsoft JET Database Engine error '80040e14' Invalid bracketing
at "I&D Parrth."
infact the there exists a fieldname as "I&D Parrth." when I removed the "." character , the data ported without any error.
please provide me with a solution to handle the special character "." i even used [ ] braces, but it did not help.
please help ...