UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Parse Hl7 Messages In Access Db, Access 2013    
 
   
fitzdesignz
post Sep 26 2019, 03:03 PM
Post#1



Posts: 74
Joined: 14-June 18



I'm seaking advice on a third party software that can Parse HL7 messages into Access DB.

Anyone know of anything that can do so?

--------------------
-Fitz
Go to the top of the page
 
jleach
post Sep 26 2019, 03:19 PM
Post#2


UtterAccess Administrator
Posts: 10,287
Joined: 7-December 09
From: St. Augustine, FL


Hi,

What do you want to parse it for: display purposes or storage in a table?

I'm not aware of anything for VBA/Access, but there's a number of tools around that will do one or the other. Probably in this case I might look into a C# version and wrap it in COM wrapper to call from VBA (simply because a .net version is going to have far better community support than a VBA one).

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
GroverParkGeorge
post Sep 26 2019, 06:06 PM
Post#3


UA Admin
Posts: 36,211
Joined: 20-June 02
From: Newcastle, WA


I recall a thread here from a few months ago on a similar topic, although I don't know the specific dates. If you search here you might turn up a discussion or two with useful information or links.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
fitzdesignz
post Sep 27 2019, 10:51 AM
Post#4



Posts: 74
Joined: 14-June 18



The idea is that a medical charting device dumps the HL7 file into the folder and a integration engine (The software I'm looking for) grabs that file, reads it and extracts the info I need and places into its corresponding fields/Tables in a Access DB. Plenty of options for a SQL, but Access? not sure. Also most of these are extremely pricey. Like fancy new car pricey.

--------------------
-Fitz
Go to the top of the page
 
GroverParkGeorge
post Sep 27 2019, 11:27 AM
Post#5


UA Admin
Posts: 36,211
Joined: 20-June 02
From: Newcastle, WA


It may be that you're swimming in those waters, then.

It's an elaborate work around, but have you considered installing a local instance of SQL Server Express to perform the data extraction and write it to a table that you can link to from the main Access accdb. That's assuming you can do it as you suggest from SQL Server....

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th December 2019 - 06:14 AM