Home » RDBMS Server » Server Utilities » Microsoft Access Data (Oracle,9i,XP)
Microsoft Access Data [message #376908] Fri, 19 December 2008 02:03 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

I have to upload more than 200000 records with 15 columns from Microsoft Access file into oracle 9i database.I am trying to upload it by first download it into excel but excel cannot support that much data.kindly help me.


regards

Zuhair

Re: Microsoft Access Data [message #376910 is a reply to message #376908] Fri, 19 December 2008 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Save the data in a CSV file and then use SQL*Loader to load it into Oracle.

Regards
Michel
Re: Microsoft Access Data [message #376911 is a reply to message #376910] Fri, 19 December 2008 02:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
One should be able to map Oracle tables in Access via ODBC. When done the Oracle table will look like a local table and you can just copy the data across.
Re: Microsoft Access Data [message #376963 is a reply to message #376910] Fri, 19 December 2008 04:40 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
First of All, Thanks for the reply, I have searched for the option of saving microsoft access file into CSV format but Microsoft Access does not provide any facility of saving Microsoft access file into CSV file.One more thing I need to mention,I am using Microsoft Access 2003.please assist
Re: Microsoft Access Data [message #376990 is a reply to message #376963] Fri, 19 December 2008 06:06 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look at Oracle Migration Workbench

Then you could download and install the workbench with msaccess plugin, if it's suits the purpose.

[Updated on: Fri, 19 December 2008 06:09]

Report message to a moderator

Re: Microsoft Access Data [message #377081 is a reply to message #376990] Sat, 20 December 2008 00:37 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
thanks for the support ,but unable to find "workbench with msaccess plugin" on the provided url.
Re: Microsoft Access Data [message #377088 is a reply to message #377081] Sat, 20 December 2008 01:16 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
As far as I understand the MS-Access migration component was moved to SQL Developer.
Re: Microsoft Access Data [message #377091 is a reply to message #377088] Sat, 20 December 2008 01:56 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
hmmmm,didnt find,i will highly appreciate you if you could give me proper url of downloading the software.
Re: Microsoft Access Data [message #377096 is a reply to message #377091] Sat, 20 December 2008 02:16 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is the Oracle SQL Developer homepage. Everything you need to know about it can be read on that page (or pages linked to it).

OTN: What is SQL Developer (excerpt)
SQL Developer includes the Migration Workbench, redeveloped and integrated to extend the functionality and usability offered by the original Oracle Migration Workbench. Its tight integration with SQL Developer provides users with a single point to browse database objects and data in third party databases, and to migrate from these databases to Oracle.
Re: Microsoft Access Data [message #377298 is a reply to message #376908] Mon, 22 December 2008 04:54 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear all

Once again,thank you all of you who supported me ,Now I have downloaded and installes sql developer but unfortunately unable to use it successfully ,I have seen the help of SQL developer but after work for 2 hour no output come,if someone guide me regarding data migration by using sql developer then i will really appreciate.

Regards


zuhair

Re: Microsoft Access Data [message #377300 is a reply to message #377298] Mon, 22 December 2008 04:57 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
That is a very vague request. Can you please be more specific? What happens when you try? Do you get any errors?
Re: Microsoft Access Data [message #377319 is a reply to message #376908] Mon, 22 December 2008 05:53 Go to previous messageGo to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks for the reply,I have done the following steps.

open sql developer
under migration,click quick migration
quick migration wizard diaglog box appear,click new,
in the oracle tab, input the following information
input connection name 'zuhair',give user name and password (sys/s),check save password option,give role "sysdba" ,give connection type "basic",didnt check any any check box like os authorization and others,give host name 'zkhan-dfml',port '1521',sid 'dba' and then push the test button and then status show "success"

in the access tab, input the following information
input connection name ,input mdb file name by using browse button,after this step click test button then the following message display 'test fail odbc microsoft access driver not a valid password

I have tried to create odbc link but i think i have done some thing wrong,kindly help
Re: Microsoft Access Data [message #377433 is a reply to message #376908] Tue, 23 December 2008 01:00 Go to previous message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
waiting for your positive response
Previous Topic: SQL Loader (Urgent Need immediate reply)
Next Topic: Error during import
Goto Forum:
  


Current Time: Sun Dec 04 20:59:05 CST 2016

Total time taken to generate the page: 0.08740 seconds