Noob problem

[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.

 

[Nikos Yannacopoulos]

For only a few tables, try manual export. Select a table
and go to menu File > Export. Choose file type text, and
the wizzard will guide you through the rest of the
process. I would suggest delimited files for the purpose.

Nikos Y. (nyannaco at in dot gr)