Health IT and Electronic Health Activate your FREE membership today |  Log-in
5 pts.
 Legacy Systems
Our Clinical data is in a highly refined/adapted version of ACT! Will it be possible to "import" it into a real EHR system? ACT! is ODBC compliant.

Software/Hardware used:
ACT! for clinical, Quickbooks for financial
ASKED: May 17, 2011  10:02 PM
UPDATED: May 23, 2011  2:32 am

Answer Wiki:
I think some of the newer versions of ACT! are actually using SQL compact database. This is very userful as you can tecnicly open that (or attach it to your sql server) using Microsoft Management studio and create more advanced queries that can be then used to load your data into the EHR. But be aware that every EHR system is different. The best approach would be to actually tune your queries to create data that is needed to create a CCR/CCD message, then ask your EHR message to import or process those data files. The only reason I say that is that it can get real messy when trying to import data directly into certain tables of the EHR database. It can be a disaster and at times you will be left alone with no assistance from the vendor since they would not typically support this type of conversion directly per say.
Last Wiki Answer Submitted:  May 23, 2011  2:32 am  by  RedaChouffani   1,785 pts.
All Answer Wiki Contributors:  RedaChouffani   1,785 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: