Hi All,
Is it possible to store a carriage return in a table and then retrieve it to Excel.
This is the method I am using to call the query:
Code:
Set RecSet = Db.OpenRecordset(strSQL, dbOpenDynaset)
Sheets(Sheets.Count).Cells(1, 4).CopyFromRecordset (RecSet)
Right now, in the Access table, an example row looks like:
Code:
Service Charge $14.50 & Chr(13) & Chr(10) & SHIPPING CHARGE CORRECTION AUDIT FEE FEE BASED ON 11 PACKAGES AND $377.86 CORRECTION AMOUNT $22.67
When I copy the record set to Excel, the cell displays exactly as above and not what I would expect, which is:
Code:
Service Charge $14.50
SHIPPING CHARGE CORRECTION AUDIT FEE FEE BASED ON 11 PACKAGES AND $377.86 CORRECTION AMOUNT $22.67
Thanks for the help!