Re: French characters

"Alt255" <alt255.2005_at_gmail.com> wrote in message news:1147873711.139122.22520_at_38g2000cwa.googlegroups.com...
> 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.
>

The problem is putting the wrong sized characters in a database that can't handle it. (because of the initial wrong set up of the database) Jim Received on Wed May 17 2006 - 09:11:46 CDT