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.
    >
    > 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


    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


    >
    > 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.


    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

    >>
    >> 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.

    >
    > 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 the transaction 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


    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

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.
Similar Threads
  1. SteelDetailer

    "Licensing" utility for protecting my Excel code

    SteelDetailer, Feb 10, 2004, in forum: Excel Programming
    Replies:
    0
    Views:
    98
    SteelDetailer
    Feb 10, 2004
  2. meldrape
    Replies:
    7
    Views:
    137
    Mel Draper
    Jun 15, 2004
  3. Martyn
    Replies:
    6
    Views:
    140
    Martyn
    Jun 25, 2004
  4. Amit Shanker

    ToDo utility in Excel VBA?

    Amit Shanker, Feb 11, 2005, in forum: Excel Programming
    Replies:
    8
    Views:
    117
    scattered
    Feb 15, 2005
  5. .NetProf

    want to create utility for excel sheet!!!!!

    .NetProf, Jan 27, 2006, in forum: Excel Programming
    Replies:
    3
    Views:
    103
    Bob Phillips
    Jan 30, 2006
  6. headley sappleton

    Any utility for joining two or more Excel or CVS files

    headley sappleton, Feb 8, 2006, in forum: Excel Programming
    Replies:
    1
    Views:
    109
    Peo Sjoblom
    Feb 8, 2006
  7. Martina
    Replies:
    0
    Views:
    124
    Martina
    Jul 26, 2006
  8. Satish S. Joshi
    Replies:
    1
    Views:
    110
Loading...