This content has been marked as final. Show 5 replies
YES,using one of Oracle's sql loader utility. Also using sql developer tool , You can take the Excel file soft copy and can directly load into the oracle database. Check the docs.
995773 wrote:On PC running EXCEL you can install Oracle client software; then using ODBC Excel can connect directly to Oracle DB & issue SQL against Oracle DB.
I m new comer in the Oracle world. I see everywhere Oracle take the place, So I try to know abt this. I m in MIS Dept.
In my company (Clifton Group a big Company on Garments sector) every month we recruit many employee. The personnel dept. entry there Name, Father Name, Mother Name, Age, Dept, Section, Joining Date etc. in Excel file & send me the hard copy.
Yes you can,
Infact you have two alternatives
1. Either you can export from MS Access this is how you do it
1.1. create a Data source name (DSN) going to control panel > administrative tools > Data Sources (ODBC) ---- if you have never created any before google a little about it
1.2. open the table of your form in MS Access and right click it --- then select export ---- then select to ODBC database ---- then select the DSN that u created above and export
2. Downloand SQLDeveloper from oracle site
2.1. open it and connect to your database using sqldeveloper
2.2. under your database connections...select the table sub menu and right click it
3.3. use the import menu item and follow the wizard to import
I believe that one of the main functions of IT in a business is to enable the business to do their job as efficiently and accurately as possible, not to do their work for them. Having the business enter data into a spreadsheet which is then manually entered to a database is neither accurate or efficient, and automating the upload of data at your end is only a slight improvement. In this case, I would be looking to give your personel department some form of direct access to the database and cut out the middle man, and save you a lot of work in the long run.
Unfortunately, you haven't specified the Oracle database environment you are loading data into EG E-business suite, Peoplesoft, inhouse etc. but would it be possible to give the users access to the frontend that accesses this database. If that is not possible, can you write your own app that can satisfy this business case. A good tool for doing this is Application Express.
Another alternative, though less desirable, is to build an application in MS Access that uses your oracle database accessed through ODBC.
Hope this helps
DO NOT USE MS ACCESS AS AN ORACLE CLIENT!
Numerous reasons from flexibility, manageability, to performance and security.
USE <a href="http://apex.oracle.com">APPLICATION EXPRESS</a> (APEX).
Apex is basically a MS-Access version for Oracle that runs via thin client-server. The client is a web browser. Nothing more needed. Apex supports creating data entry input forms and reports. It is easy enough for a newcomer to use that has next to no experience of web-based client-server. It handles state and security for you. It is also flexible and powerful enough for a web developer to develop Web 2.0 applications with rich user interfaces, using HTML5, JQuery, ExtJS, and so on.
Apex is free. Is included with the RDBMS software (installs by default). New versions/upgrades are available for free. Users only need a web browser (Firefox, Chrome, Safari, Operah, IE) to use an Apex application.
Compare this to MS Access that needs a license, only supports Windows users, and need a working Oracle client driver installation and a correctly configured Oracle ODBC driver.