and to move the "tables" from access you could use the "Migration workbench" that you can get from OTN /torben holm
Peter Gram wrote: > Dennis > > > Move the tables into Oracle and let the users use Access via odbc ;-) > > [EMAIL PROTECTED] wrote: > >> Good day all, >> I have been asked the following question a couple of time by our >> database >> users - >> They have a bunch of small Access databases that they want to port into >> Oracle. Since most of these databases have just a few tables in them I >> figure I can use sql loader to load the access tables into Oracle. >> But the >> tough part is, how do we have the users access the data once it is in >> Oracle? Since these are pretty static databases and we don't have the >> resources in house to develop front end tools to retrieve the data, I am >> wondering if there is a slick, user friendly tool out there can help us >> with this. Toad partially satisfies this need but I think it is an >> overkill >> for data access only. Also, it would be nice to have a web browser >> interface and some data insert and update capabilities without using >> sql. >> Alright I know now I am really push it... >> >> TIA >> >> Dennis Meng >> Database Administrator >> Focal Communications Corp >> >> > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Torben Holm INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
