Hi All


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 ...

regards
Sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

Hi there,

Can post on how you were referencing the database objects in your case?

Cheers!

_________________________
- Vijay G
Strive for Perfection