Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: import data
Both programs have options to write a text file with delimiter (in
accsess you can define wich delimiter you want). Then you use sql-loader
taking the file and specifying the delimiter and the table you want to
load. The program will take the fields as they are presented in order so
I will repeat the loading.Ej.
no,name,address,no,name,address,no,name,address so you must make sure
that your file corresponds with the insert in the sql-loader script.
claudio_montoya_at_my-deja.com wrote:
>
> Can someone help me?. I trying to import data to
> an Oracle Database from an Access table or from a
> Excel file but i canĀ“t.
> What can i do?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 04 2000 - 20:42:51 CST