access转移到oracle的一种方法(转贴)
How to export Access tables to Oracle[@more@]Install an Oracle ODBC driver How to create a data source based on a machine with an Oracle database Select Export from the File menu Make sure that the export will go to an external database Choose ODBC as the file type and select the datasource The biggest problems are (going from Access to Oracle): Hidden ColumnsMake sure you unhide all columns, they may cause problems Names mixed case names- these go over to mixed case names in Oracle