Access table to Oracle

[bd528]

Hi all,

I need to move some data from my Access database to Oracle.

To setup the oracle tables, I need a Make Table query that "makes" my Access table (data types, etc)

Is there a way to do this, in or out of Access?

Thanks in advance

 

[Ranman256]

You can't make tables in oracle thru access.
They must be made via an oracle app.
Then linked into access.
Then access can append records.

 

[bd528]

That makes sence.

But, for example, one of my tables in Access has 30 fields.

Surely I don't have to create each column manually in Oracle?

 

[Minty]

I don't think you do - I don't use Oracle but this guide suggest that just like SQL Server it's pretty straightforwards http://www.oracle.com/webfolder/tec...3.0_Import_Export/sqldev3.0_import_export.htm

 

[HiTechCoach]

Hi all,

I need to move some data from my Access database to Oracle.

To setup the oracle tables, I need a Make Table query that "makes" my Access table (data types, etc)

Is there a way to do this, in or out of Access?

Thanks in advance

Sure.

Oracle has a tool.

See:

Migrating from Microsoft Access to Oracle

Oracle SQL Developer is a free and fully supported product that provides tools and utilities to migrate from Microsoft Access to Oracle.

You will definitely want to do lots of testing.

Getting the data types correctly in the Oracle (or any SQL Server) back end that is compatible with Access is the tricky part.

If it were mine, I would build the table(s) in the Oracle database manually to be sure it uses the correct data types..

 

[bd528]

Sure.

Oracle has a tool.

Thank you.

 

[HiTechCoach]

You're welcome.

Glad we could assist.