Re: Access => Oracle

Hi Lucas,

You can of course always use Access to dump your tables to a csv file. On the Oracle side one would then have to use sqlloader to get the data back in.
If you have only three tables this sounds like a very easy job. Officially my employer doesn't allow me to do this (I am working for a Dutch IT consulting firm), but I believe the whole intake procedure would take longer than developing the scripts, given all the involved bureaucracy.

I have Access 2000, I have Personal Oracle 8i, I am in the 'leegloop'/availability, at least the next two days, and may be next week also, so if you can zip up that database (preferably with data), and e-mail and/or put it on an ftp-site somewhere, I am willing to give it a shot. And, on a side note, I visited Alden Biesen in Bilzen/Rijkhoven for music courses during 10 years, so I did learn to value your country.

Regards,

Sybrand Bakker, Oracle DBA

"Lucas Verhelst" <Lucas.Verhelst_at_ping.be> wrote in message news:902jfo$f90$2_at_news.planetinternet.be...
> Hi,
>
> I have a client who would like a delivery of an Oracle database for his
> server.
>
> We are a little entreprise that works actually with PWS and Acces.
>
> We understand that for frequently consult of databases by a lot of
> participants Access is not strong enough.
>
> I consulted Oracle and they gave me a bunch of paper with contracts
> I concluded that I can not "buy" Oracle, install it, learn how to
> set up tables, and deliver the database for ODBC/SQL purposes.
>
> So, is ther anayone amongst you that can make a convertion
> program/scriupt for Access=> Oracle , so I can use it to run
> as a kind of "save as" on the Oracle server of my client ?
>
> Details : there a three tables
>
> 1) is used to add records of students
> (Name, Firstname, pasword, id(keyfield), language (French or Dutch))
> 2) is used to hold strings of scores and time for every lesson/student id
> 3) is a static one with all the texts in 2 cols (French, Dutch)
>
>
>
> I hope you can help me ... (I am of course willing to pay a price for
 it..)
>
>
> Lucas
>
>
>
>
Received on Wed Nov 29 2000 - 11:18:00 CET