Some Tables from Access to Oracle

  • Thread starter Juan Enrique Bellon
  • 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.
 
N

Nick

Juan,

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

N
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top