[AccessD] EDI data file

Thanks Marty that helps.  It is a Remittance Advice file so now I at least
know the template id (which I think was on the web site Steve mentioned as
well).  Sounds like I have a lot of learning to do.

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Monday, November 03, 2003 3:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] EDI data file


You can translate or map EDI to csv, flatfiles or xml
 I suggested to one company to convert or map  to xml then bring into 
Access or SQL via ADO or XMLDOM.
 They used  goXML product from Altova with XMLSPY to do the conversion. 
It is expensive but necessary if you have a lot of different EDI 
formats. There are different templates for EDI X12
like 850 and 810. or
HIPAA templates ::
EDI X12 - 270 Eligibility, Coverage or Benefit Inquiry
EDI X12 - 271 Eligibility, Coverage or Benefit Inquiry
EDI X12 - 276 Health Care Claim Status Request
EDI X12 - 277 Health Care Claim Status Notification
EDI X12 - 820 Payment Order Remittance Advice
EDI X12 - 834 Benefit Enrollment and Maintenance
EDI X12 - 835 Health Care Claim Payment Advice
EDI X12 - 837 Health Care Claim

A cheaper conversion program would be ETAsoft for around $2000
http://www.xtranslator.com/index.htm

There is a recent book on subject with examples  but uses Java C++
Using XML with Legacy Business Applications
by Michael C. Rawlins
http://www.amazon.com/exec/obidos/ASIN/0321154940/qid%3D1063200555/sr%3D11-1
/ref%3Dsr%5F11%5F1/002-5838316-1411229

You might find cheaper translation software at www.xml.org or 
www.oasis.org or maybe MS eBiz server site

rusty.hammond at cpiqpc.com wrote:

>Has anyone ever worked with an X12/EDI data file?  Can it be imported into
>an Access 97 table?  We're getting a file back that we're supposed to use
to
>lookup the status of billings but it needs to be parsed.  The (very)
limited
>help on the web site where we download the file from says we need to use a
>conversion program to get the X12 file to a readable format.
>
>Any help would be much appreciated.
>
>TIA
>
>Rusty
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com