developers

    Forum Stats

  • 3,874,066 Users
  • 2,266,672 Discussions
  • 7,911,718 Comments

Discussions

Connect from Excel to APEX

628828
628828 Member Posts: 57
edited Oct 13, 2008 6:22AM in APEX Discussions
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
Tagged:

Answers

  • 468750
    468750 Member Posts: 142
    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
    Roel Hartman Member Posts: 2,711 Gold Trophy
    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
    628828 Member Posts: 57
    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
    Roel Hartman Member Posts: 2,711 Gold Trophy
    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/
This discussion has been closed.
developers