Have narrowed this down to a problem with the "[tblCustomerSection$.ChangeRequestTitle]" field. The query would work if I did the following:
But when I add in the extra "[tblCustomerSection$.ChangeRequestTitle]" field I get the error I received above. Any ideas about why this could happen with excel fields? It's just a select statement. I can't figure out whether it's an ado problem or an excel field spreadsheet problem. If noone can answer what other options can I use apart from ado for adding,updating spreadsheets?
Thanks.
Bookmarks