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!
convert table from ms access to oracle
- Thread starter ociruj
- Start date
Hi,
First prepare the Access table to be Oracle compatible ( and easy to use):
1: ALL UPPER CASE table and field names.
2: No spaces or other 'special' characters in table or field names
3: Change MEMO to TEXT or they will become LONG types in Oracle and cause problems.
Then use the File..Export..command from Access to export to Oracle over a pre-defined ODBC connection.
If you need to do this on a regular basis ( or for many tables), look into the Oracle Migration Workbench.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
First prepare the Access table to be Oracle compatible ( and easy to use):
1: ALL UPPER CASE table and field names.
2: No spaces or other 'special' characters in table or field names
3: Change MEMO to TEXT or they will become LONG types in Oracle and cause problems.
Then use the File..Export..command from Access to export to Oracle over a pre-defined ODBC connection.
If you need to do this on a regular basis ( or for many tables), look into the Oracle Migration Workbench.
- Status
Similar threads
- Locked
- Question