how do I import an access table to Oracle9i?

[lhugh]

thansk

 

[Turkbear]

Hi, You don't, at least not directly.
You can
1: Create a link to the Oracle instance you want to place the Access table in and Export it.

2: Generate a delimited file from the Access table and use SqlLoader to load it into your Oracle instance.

 

[amortillaro]

Go

http://otn.oracle.com/documentation/migration.html

You have to download the Oracle Migration Workbench, then download the pluggin for Access, install and run.
Let us know... Aishel

 

[acct98]

If you are going to use SQL Loader I would suggest the following book:
Oracle Sql*Loader the Definitive Guide

 

[lhugh]

thank you all