MartyConnelly
martyconnelly at shaw.ca
Mon Nov 3 15:49:41 CST 2003
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