Hello,

We have the UK version of Quickbooks and we bring data into Access thru an ODBC pass thru query.

In the memo fields in the invoiceLine table, we have non-english characters.  When we show these onto an Access Report, the characters do not convert correctly.  Is there a way to overcome this? 

Thank you for your help.

Chris

If the character replacements are unique, you can replace them with the correct character as the memo field is extracted from QuickBooks.

See: where are my carriage returns/linefeeds? 

I tried the replace function as you suggested.  I even debug.printed each character code of the string coming back from ODBC.  Unfortunately, the replacements are not unique.  It seems like any greek character letter without an english equivalent is replaced by a certain ascii code character.

Is there an ODBC function that will return the original string in the field without character conversion taking place?

With a little care, you can try using the RAW table instead. For example:

select RefNumberraw, CustomerRefFullNameraw, Memoraw from Invoiceraw

Check the Include Raw Files: option in the QODBC Setup Screen to access them.