• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1128
  • Last Modified:

export table definition to Oracle

How do I export the table definitions of an Access database (including column names, field types and sizes) so I can run create table SQL in Oracle?
0
freedmanrp
Asked:
freedmanrp
  • 3
  • 2
1 Solution
 
paaskyCommented:
freedmanrp, send me your email address and I will send you an MSAccess97 to Oracle utility I've done for my own use.

Regards,
paasky
0
 
paaskyCommented:
(my address apaasky@hotmail.com)
0
 
ornicarCommented:
You can also use the Oracle Migration Workbench. It can be downloaded from www.technet.oracle.com.
0
 
paaskyCommented:
ornicar, is it same that cames with Oracle installation CD-ROM? If it is, it requires connection to Oracle database to work and doesn't create SQL files... that's why I decided to create tool of my own. I can email it to anyone who is interested.

Regards,
Paasky
0
 
ornicarCommented:
Hi Paasky,
You are right, it does not create sql scripts.
I am very interrested in your tool me too, could you email it to me? I would be very pleased (Edited by C101))
Thanks, and again, you are doing a great job!
Cheers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now