I currently receive 834 Benefit Enrollment files each week that need to be compared. I canview the data using a parser or EDI notepad, but I need to compare large amounts of data for changes. Is there a way to convert the file to an Excel worksheet that has usable data? I'm a bit of a dummy when it comes to this, so the easier the solution the better. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert 834 file to Excel
- Thread starter gbiondo73
- Start date
NasibKalsi
Programmer
Can you save the file from your Parser or EDI notepad to a Tab delimited or CSV file. If so, then save all the exported files with the proper names in a separet folder. Now import in Excel this newly created file(s).
I hope it will help.
Nasib
I hope it will help.
Nasib
- Status
Similar threads
- Locked
- Question