Access output to HL7

[HJAMES]

Has anyone been successful in exporting data from an Access Table/Query to HL7?

We're pretty close but having problems with the creating actual records. Our data come from a flat table and we are trying to break it up into several acsii records using a query.

Any suggestions?

 

[WayneRyan]

H,

If you showed your table format and the desired output file
formats, then we could address it.

Wayne

 

[HJAMES]

I'm sorry but it's to complex to post - I was hoping someone already familiar with HL7 had already done this and could shed some ideas.

 

[boblarson]

I've done some programming around taking an HL7 lab file and parsing it and sending the pieces to tables in Access.

 

[HJAMES]

Thanks, we've been able to do that too. We're having problems with output. To be specific - the end of record processing.