MS-Access to Oracle
in [Oracle Help]
|
Prev: 11g OEM - dictionary comparison - Selecting another database instance for comparison
Next: 11g OEM - dictionary comparison - Selecting another databaseinstance for comparison
From: timmg on 11 Jun 2008 13:27 Moving tables from MS-Access to Orcale 10g changes double field types to Varchar2. Any ideas why and suggestions on how to get them to numerics? Thanks, Tim Mills-Groninger
From: Ed Prochak on 11 Jun 2008 13:44 On Jun 11, 1:27 pm, timmg <tmillsgronin...(a)gmail.com> wrote: > Moving tables from MS-Access to Orcale 10g changes double field types > to Varchar2. > > Any ideas why and suggestions on how to get them to numerics? > > Thanks, > > Tim Mills-Groninger 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
From: timmg on 12 Jun 2008 10:48
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...(a)gmail.com> wrote: > On Jun 11, 1:27 pm, timmg <tmillsgronin...(a)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 |