Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connect from Excel to APEX

628828Oct 13 2008 — edited Oct 13 2008
Hi all,

I want to transfer data entered through a template in excel into tables in the APEX Environment.
There are several users who will enter data in the excel and this must be uploaded automatically in my APEX tables .
How can I do that ?

Thanks,
Adela

Comments

468750
Adela,

There are a lot of questions about this sort of thing on the forum. Search for upload csv data

You have to create an application that will browse for your file and parse the data (usually in csv format) into your tables.
Check out the following links to see which you prefer...

624911

547565

336988

http://advait.wordpress.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/


this solution from vikas his downloadable and you can then modify it for your own use...
http://htmldb.oracle.com/pls/otn/wwv_flow_custom_auth_std.login_page?p_flow_page=38131:1:1287783765705596

Gus..
Roel Hartman
Hello Adela,

My first reaction is : Why would you do that? Why not create a report and form in APEX and let the users enter and query data using APEX??? Makes everybodys live so much easier - and more fun ;-)

But if you (or your users insist): This has nothing to do with APEX. You need an ODBC connection from Excel to your database that updates your database tables (not your APEX tables, because that is the repository - and you certainly don't want the users change the repos tables using Excel).

Regards,
Roel

http://roelhartman.blogspot.com/
http://www.bloggingaboutoracle.org/
http://www.logica.com/
628828
Thank you both for your quick replies.

Gus - I've seen the posts on the upload csv, but what I needed was when data was submited from Excel to automatically be stored in my APEX application.

Roel - The Excel application is already builded and by other team so that's why I need to make a connection to that and not build it directly in APEX.
where and how do you make the ODBC connection?

Many Thanks,
Adela
Roel Hartman
Hello Adela,

The question "How to setup an ODBC connection in Excel" is better asked in the Windows/ODBC forum. Check [this message|http://forums.oracle.com/forums/thread.jspa?messageID=2731900&#2731900]. I guess the answer is there - or at least the path to the answer....

Regards,
Roel

http://roelhartman.blogspot.com/
http://www.bloggingaboutoracle.org/
http://www.logica.com/
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2008
Added on Oct 13 2008
4 comments
761 views