Re: Conversion tool for Access 97 -> Oracle 7 database

armaghan_at_usa.net wrote in article <6173tk$cdh_at_drn.zippo.com>...
> Does any one know about some tool/product which exports entire mdb of
 Access 97
> to oracle database and possibly can convert field names in lowercase to
 upper
> case.
>
> Oracle used to carry such a utility on its web site for Access 2.0 but i
 can't
> find it now over there.
>
> Another problem I am facing is how to convert table/field names from
 lower case
> to upper case when exporting a table using ODBC.
>
> Help regarding any of above questions will be appreciated greatly.
>
> Thanks in advance
> M. Armaghan Saqib
> armaghan_at_usa.net
>
Armaghan,
As a serious data converter I recommend you look at SQLMover which is a production or on-demand tool for DBAs or the DB knowledgeable that allows you to replicate automatically between any ODBC compliant datasource including Oracle, Ingres, Informix, DB2, all MS databases including SQL
Server, Access and Excel. You need the Intersolv ODBC driver for Oracle. It does not generate DLL in the present edition. The Access 32-bit ODBC driver is downloadable from www.sqlmover.com as well. SQLMover uses standard, simple or complex SQL Select statement in
one end and a INSERT, UPDATE, INSERT then UPDATE, UPDATE the INSERT or DELETE statement towards the destination database table. It has error control and logging facilities. Data conversion can be performed by using the SQL SELECT CONVERT option or by using string functions in the SELECT query, by using the built in Format Mask functions or by using triggers in the destination database. To evaluate until Oct.31 you can download from www.sqlmover.com (follow the download buttons) and use the evaluation key OSHKSHTD. The key allows you to transfer a limited number of rows per transfer/replication task and max. 5 tasks
can be defined.

For Data Mart Data Warehousing purposes you can choose to let SQLMover aggregate your data by using SELECT - GROUP BY. That is if you don´t want to transfer all details.
Peder Holst,
pederh_at_elektrosoft.se Received on Thu Oct 09 1997 - 00:00:00 CEST