Some Tables from Access to Oracle

  • Thread starter Thread starter Juan Enrique Bellon
  • Start date Start date
J

Juan Enrique Bellon

Hi, I don't have really nice experience in Access, i will
show my problem and pls help me if u can.

I have a MS Access 2000 database, i need to move few
tables from this enviorement to an Oracle DB (only few
Tables with many records inside), my boss told me about
the possibility of create some plain text files with
separators and import those files into Oracle using
SQLLOADER, and my problem is find the mode of create this
files by an automation... could be using a Macro?

Where can i find information about this kind of macro?
Any other idea?

The problem is the period of this procedure (15 days)
avoid the use of manual loading :S

Thx in advice.
 
Juan,

Why not create the tables in Oracle. Then construct a
append query in Access and append the data that way.

N
 
Back
Top