Utility to flatten/import X12 834 file into Excel

[zychtim]

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

 

[GS]

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

 

[zychtim]

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

 

[GS]

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