Re: French characters

Hi Laurenze,

I guess I have to elaborate on my situation. I'm a contractor for a large organization using MS Access to create reports from a Oracle Data Warehouse used through-out the corporation. I am the System Analyst here and cannot create a new database ( though I have my own sandbox). I must use the existing tables with the French fields. I would create a local table in Access, but some of our product tables ( with French descriptions) have 50,000 records changing regularly. I have been considering using Impromptu to create a daily extract, and then load this into an Access table, but as we know this is a poor approach ( but if I cannot resolve this then I must).

I find it baffling that Impromptu can report the correct characters, but MS access and Excel cannot. It was this line of thinking that made me request a Microsoft resource.

I hate wasting peoples time, Laurenz, are you certain MS cannot help? I was in contact with our Senior Oracle DBA initially for a solution but he couldn't help. I'm thinking I should show him this thread, maybe his knowledge and your suggestions can get this resolved. Received on Wed May 17 2006 - 08:48:31 CDT