Re: Exporting Access DBs to ORACLE

Dear Sir:

You do not need to create specific script, If you are going to move data into the same tablestructure, use SQL*Loader.

1. export Access file into text file in fixed length or delimited format.
2. find a mashine, which has a connection to server, where Oracle located ( I do not think that server is not connected to network ).
3. ftp your file in sutable directore in text mode (not binary).
4. create SQL*Loader file (very simple, information in Oracle Utilities book). Use conventional path load - more simple.
5. Run your 'script'.

If you, after all, will have some problems, send me 2 records of your text file and Oracle table description:

SQL>spool file_name
SQL>desc table_name
SQL>spool off

I'll send you 'script'.
If I was very detail, please, forgive me.

Best wishes,
Eugene.

Rafael Algara Torre wrote:
>
> Hi,
>
> I have an MS Access DB, full of data.
> Around 2500 regs. I need to export all
> the table structure and info to an ORACLE
> system (on UNIX). I have no network installed
> in the Access machine, so I have to generate
> a text file. Once I have the table structure
> into ORACLE, am I supposed to do 2500 UPDATEs?
> If so, I'm thinking about writing a script.
> There is ODBC as well, but as far as I know
> it's for network distributed interchange of
> information.
>
> Thanks in advance. Please e-mail if possible
> --
> --------------------------------------------
> Rafael Algara Torre
> ralgara_at_dgicii.mty.itesm.mx
> ITESM Campus Monterrey
> Centro de Investigacion en Informatica
> Me‚xico, 1996.
> --------------------------------------------
Received on Thu Jul 11 1996 - 00:00:00 CEST