Utility to flatten/import X12 834 file into Excel

Discussion in 'Excel Programming' started by zychtim@gmail.com, Apr 3, 2014.

  1. Guest

    Hi.

    I have an X12 834 file and I need to get it into Excel (2007).

    I am unfamiliar with this file format, and have looked at it and it looks complicated. Just by looking at it it is not easy to figure out how to flatten it out into a more friendly-looking format in Excel.

    Can somebody help me with this? Either with an existing utility that I can purchase which does this, or with VBA code that imports it into an Excel worksheet.

    Thanks a lot.

    Tim Zych
     
    , Apr 3, 2014
    #1
    1. Advertisements

  2. GS Guest

    Hi.
    VBA has built-in file I/O functions that can be used for parsing *any
    readable file* to a worksheet. Can we see this X12 834 file so we know
    what you're dealing with? If so, attach or upload to a share site and
    post a link.

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    Classic VB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion
     
    GS, Apr 3, 2014
    #2
    1. Advertisements

  3. Guest

    Thanks...however in the meantime I looked around and found a product from Edasoft called "Mini Translator" which does the job.

    The thing about it is...834 files have hierarchical information. So it would have been a matter of figuring out from scratch how to fully populate thetransaction information based on the metadata and/or structure, something that would take some time to do (assuming I knew what I was doing).

    Thanks for your reply.

    Tim
     
    , Apr 3, 2014
    #3
  4. GS Guest

    Well, whatever Edasoft's Mini Translator does is essentially the same
    as I would do using VBA's built-in I/O functions. Glad that you fornd
    something that addresses your need. Thanks for the feedback...

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    Classic VB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion
     
    GS, Apr 3, 2014
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.