Skip to Content
avatar image
Former Member

Connect two MS Access Tables / Excel Tables

Hello Gurus,

i am new to this VC Tool and i have a question. There are 2 big MS Access tables existing on our file server and i would like to use bot tables in the Visual Composer - of course i will try to connect the tables via unique key fields. Is this possible with the Visual Composer? The next question is the same but this time i want to use Excel files instead. In both file types i got some unique fields. The merge between all files should be possible.

What are the necessary steps. Please help.

Regards,

Memo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 13, 2006 at 12:29 PM

    Hello Prakash,

    thank you very much. But i cant find in this document anything about MS Excel or MS Access?

    What is the correct page?

    Best regards,

    Memo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2006 at 12:19 PM

    This is possible.

    See this how to guide for setting up JDBC connectors:

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/92d80512-0a01-0010-32a3-cd3735bd9275

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26, 2007 at 09:31 AM

    Hi,

    I see that this question is marked "answered". Could you please show me step by step the way to connect Sap Portal to back-end system such as Access Tables or Excel tables ? I've tried to connect to Max DB database but it doesn't work. I think the problem is in "user mapping" step but I don't know how to resolve it.

    Thank you very much.

    T.Ti

    Add comment
    10|10000 characters needed characters exceeded