Hi,
I'm using ado in excel to query tables. I'm then printing a report directly to excel. I get the return fields properly returned from the database using rs.Fields() values but when I insert some of these fields within an excel worksheet, I get the "#VALUE!" error. I have the column I am sending to excel set as text. I can't understand this because the value returned from the database is coming back correctly. Any ideas why it doesn't paste some strings directly into excel? Is there some characters, excel doesn't recognise when pasted and is there a way around this.
Thanks.