How Do I Build an XSL File from an Access DB

BrantRaven on 30/09/2018 - 19:04

Hi All,

I have an Access DB and would like to produce an XSL file from the DB using the fields contained in the DB. The XSL will then be used within a program that can read XSL to transform results from the DB.

I was hoping there might be some sort of WYSIWYG type program that would allow me to read in the DB and drag and drop fields until I get the XSL I need.

I am not a coder at all, but I can muddle together some code and do know something about XSL and DBs…enough to be dangerous.

Any ideas?

Brant

Computing Software

Comments

  • retiredfeline on 30/09/2018 - 20:26

    XSL or XLS?

    XSL: a language for style sheets
    XLS: Excel spreadsheet file

    • BrantRaven on 30/09/2018 - 20:43

      XSL

      • [Deactivated] on 30/09/2018 - 20:45
        +1

        XSL isn't for storing data from Access or anything similar.

        • BrantRaven on 30/09/2018 - 21:54

          yes. I understand that.

          • [Deactivated] on 30/09/2018 - 23:23

            @BrantRaven: And you're trying to use it because?

      • retiredfeline on 30/09/2018 - 23:21

        What you probably mean then is an XSLT, an XSL Transform file. Unfortunately there is no easy way to derive a transform from the metadata, it all depends on what you intend to do with the results, whether you want to generate a web page, or a PDF file, or … Unfortunately you need to be a coder, and an XSLT coder for this.

        https://www.w3schools.com/xml/xsl_transformation.asp

        Also the input has to be XML, but generating that from the DB is the easier part.

  • [Deactivated] on 30/09/2018 - 20:37
    -2

    Excel, Access and Outlook are three biggest productivity holes in business.

    If it is being ingested into another system, a csv should be fine too.

  • [Deactivated] on 01/10/2018 - 05:51

    Make a database and an XSL "form letter"?

Login or Join to leave a comment
Login Join