Re: Need help with Loader???

[Quoted] I'm not too familiar with sqlloader but the odbc is fairly simple. It goes something like this:

• Control Panel | ODBC sources | + create an oracle odbc source to your oracle db
• Access + Tables | Insert | Link Table | From the file menu choose file type "ODBC Source" + It should come up with a wizard fill it out + Do a Select All in your access table + Goto your link table and do a paste (If your data types are the same or are a greater capacity it will work, it basically does and insert statement for every row)

Elias Asfaw-Kirby
elias at icpsr dot umich - edu

--
---
"Martin Doherty" <martin.doherty_at_oracle.nospam.com> wrote in message
news:kH1y9.20$E23.89_at_news.oracle.com...


> SQL*Loader is a batch load utility that comes supplied with every Oracle

> database server installation. I think in Unix, the program file name is

> sqlldr but don't quote me. It has been around for donkey's years, and

> allows you to do a batch load of many rows into multiple tables from

> ASCII text files. Simply, you create a control file to go with your data

> file and then run the sqlldr program with the control file name as a

> parameter. The control file specifies the data file name, and the

> table(s) to load data into, and the rules about which datum goes into

> which column. Fairly powerful, lots of options and data transformation


> abilities.


>


> As per the advice from another poster in another newsgroup, check

> tahiti.oracle.com documentation for further info. Look for the Utilities


> manual.


>


> Since your data is already in an Access table, you might be able to use

> an ODBC link and use SQL to copy your rows from Access to Oracle.

> Unfortunately I don't know anything more about how that would be done

> but you will probably find the answer if you search the Google archives

> of these oracle newsgroups. Which should always be your first action

> before posting new questions to the groups anyway (since the same


> questions get answered over and over and over and .... )


>


> Martin Doherty


>


> Romeo wrote:


>


> >hello all.... im doing a class database on 8i and need to populate


> >some tables with records stored in MS access.  I heard of something

> >called loader??? will that help me?  How will I get it and how will I

> >go about using it?  I hope I don't have to enter in each of the 1000

> >records manually.  Thanks for any help.

> >

> >

>