dbTalk Databases Forums  

MS-Access to Oracle

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc MS-Access to Oracle

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss MS-Access to Oracle in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
timmg
 
Posts: n/a

Default MS-Access to Oracle - 06-11-2008 , 12:27 PM





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

Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-11-2008 , 12:44 PM





On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) com> wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Ed Prochak
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-11-2008 , 12:44 PM


On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) com> wrote:
Quote:
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


Reply With Quote
  #4  
Old   
Ed Prochak
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-11-2008 , 12:44 PM


On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) com> wrote:
Quote:
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


Reply With Quote
  #5  
Old   
Ed Prochak
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-11-2008 , 12:44 PM


On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) com> wrote:
Quote:
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


Reply With Quote
  #6  
Old   
timmg
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-12-2008 , 09:48 AM


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 (DOT) com> wrote:
Quote:
On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) 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


Reply With Quote
  #7  
Old   
timmg
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-12-2008 , 09:48 AM


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 (DOT) com> wrote:
Quote:
On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) 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


Reply With Quote
  #8  
Old   
timmg
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-12-2008 , 09:48 AM


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 (DOT) com> wrote:
Quote:
On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) 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


Reply With Quote
  #9  
Old   
timmg
 
Posts: n/a

Default Re: MS-Access to Oracle - 06-12-2008 , 09:48 AM


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 (DOT) com> wrote:
Quote:
On Jun 11, 1:27 pm, timmg <tmillsgronin... (AT) gmail (DOT) 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


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top