Critical Developers

Programmers Knowledge Base

Read and Process 835 ERA (Electronic Remittance Advice) using ASP.Net and SQL Server

How to read EDI file 835 in and sql server -

Find the below algorithm to read and process ERA 835 file:-

1) Upload 835 file and convert it to Excel XML or CSV using code here.

2) Convert XML or CSV to a DataTable.

3) Import the DataTable to a Sql Table (e.g. tblERA835ImportedData) using Sql BCP.

4) Write a stored procedure to insert credit transaction entry (you can use cursor or while loop in sql)

Note:- Validate 835 file Before uploading. (Just check the file has ISA segment with 106 characters in length)