Is that possible to import table data from ms access to oracle sql ?

Question

i mean can i import the details on my database found in ms access to oracle sql.
So that i do not have to re input data
Thank you

Answer 1

Yes it is perfectly possible, consider that both Oracle and Microsoft implement their own functionalities to SQL, which makes them different on details, but both work perfectly fine with the SQL standards, and when you export a table you would find common ground by doing some cleaning if necessary. Here's mysql export table example:

CREATE TABLE IF NOT EXISTS `customers` (
`Id` int(4) NOT NULL,
`cust_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`cust_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`language` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`start_date` date DEFAULT NULL);

You would have to remove "IF NOT EXISTS" from the create table statement, and remove "COLLATE utf8_unicode_ci " from the columns. If you do this, which I'm calling "cleaning", you would be able to import the customers table from mysql to Oracle or Access. Hope this helps Navin.

Answer 2

Thank you Sir Roberto Guisarre