How can i upload data from access database into oracle
Printable View
How can i upload data from access database into oracle
You can export data from access into CSV file then use SQL Loader in Oracle to load it.
You can also use Linked table from Access to directly insert into Oracle table.
thanks skhanal!!!
But i am not familier with CSV
can u explain in details
You need to export the data from Access to a standard format, CSV (comma separated values) is one way. You could also use Tab separated values.