Re: Need help with Loader???

A far better way is to use the File..Export function in Access ( after setting up your Oracle ODBC DSN) - Modify the Access table so that all Table names are UPPER CASE and have no 'special' characters ( including spaces) in them, and change all field names to UPPER CASE ( and same restrictions on special chars- This will make working with the tables in Oracle much, much easier)...
Optionally, change any MEMO fields to text ones of less than 4000 chars to avoid using LONG data types in Oracle..

( Cut and Paste is too chancy..)  

"Elias Asfaw-Kirby" <elias_at_icpsr.umich.edu> wrote:

>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
Received on Tue Nov 26 2002 - 18:48:59 CET