Re: MS-Access to Oracle

From Access I'm exporting the tables via the Export option, ODBC type using the Oracle ODBC drivers.

So, you think that moving the table to an intermediate table in Oracle, then importing into the production table is the way to go?

On Jun 11, 12:44 pm, Ed Prochak <edproc..._at_gmail.com> wrote:
> On Jun 11, 1:27 pm, timmg <tmillsgronin..._at_gmail.com> wrote:
>
> > Moving tables from MS-Access to Orcale 10g changes double field types
> > to Varchar2.

...>
> How are you "moving" the tables?
>
> The solution is to do the conversion properly and create the tables in
> Oracle the way you want them.
>    Ed
Received on Thu Jun 12 2008 - 09:48:23 CDT