Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating tables
- Thread starter filipe26
- Start date
SantaMufasa
Technical User
Filipe,
There are several methods to accomplish what you want. Among them are:
1) Create an ODBC (Open-Database Connectivity) connection between your Oracle database and your Access environment, then you should be able to log into Oracle using the ODBC connection and do a series of "CREATE TABLE <Oracle_table_name> AS SELECT * FROM <Access_table_name><plus ODBC connectivity reference>;"
2) Write your own Access script that prompts you for an Access table name, then the script writes Oracle-SQL syntax to both CREATE the Oracle table and INSERT the contents of each row of the Access table into the Oracle table.
3) Post an inquiry in the Access Forum for utilities that you can use to clone your Access table into Oracle.
Unfortunately, Oracle has no method of reading your ".mdb" files.
Let us know what you decide to do and the method you find most convenient.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
There are several methods to accomplish what you want. Among them are:
1) Create an ODBC (Open-Database Connectivity) connection between your Oracle database and your Access environment, then you should be able to log into Oracle using the ODBC connection and do a series of "CREATE TABLE <Oracle_table_name> AS SELECT * FROM <Access_table_name><plus ODBC connectivity reference>;"
2) Write your own Access script that prompts you for an Access table name, then the script writes Oracle-SQL syntax to both CREATE the Oracle table and INSERT the contents of each row of the Access table into the Oracle table.
3) Post an inquiry in the Access Forum for utilities that you can use to clone your Access table into Oracle.
Unfortunately, Oracle has no method of reading your ".mdb" files.
Let us know what you decide to do and the method you find most convenient.
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
Hi,
There is a tool form Oracle ( Called the Migration Workbench, I believe) that will make this pretty straightforward.
You can manually do it with the Export function of Access ( Assuming you have an ODBC DSN for your Oracle einstance)..
Some caveats:
Use ALL CAPS for TABLE and FIELD names
Avoid special characters ( including spaces) for these ( except for _ , if you want some table name like USER_DATA_TABLE)
Change any MEMO fields to TEXT
Tool is better idea but it can be done this way.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
There is a tool form Oracle ( Called the Migration Workbench, I believe) that will make this pretty straightforward.
You can manually do it with the Export function of Access ( Assuming you have an ODBC DSN for your Oracle einstance)..
Some caveats:
Use ALL CAPS for TABLE and FIELD names
Avoid special characters ( including spaces) for these ( except for _ , if you want some table name like USER_DATA_TABLE)
Change any MEMO fields to TEXT
Tool is better idea but it can be done this way.
To Paraphrase:"The Help you get is proportional to the Help you give.."
MartijnTonies
Programmer
You might want to give our tool, Database Workbench, a try - it includes schema migration tools and supports ADO/ODBC sources as well.
Download a trial at
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server
Download a trial at
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server
- Status
Similar threads
- Locked
- Question