northernknight
asked on
How to do a conversion from Access to txt
I am working with a client that dispenses drugs and needs to send a report at the end of the day. We have the data needed but it needs to be in ASAP 2005 format. We need to be able to convert the data to the ASAP format. We are using Access 2007 and can export a query to txt, but cannot get it to look like the ASAP 2005 format.
Here is the website that requires the format, http://www.4infinitesolutions.com/cures/ASAP2005/index.htm
I have provided the format below.
Here is the website that requires the format, http://www.4infinitesolutions.com/cures/ASAP2005/index.htm
I have provided the format below.
Sample
TH*3.0**PHY12345_010109_01.DAT*****20090105*200646*T**:\
IS*9164540168*ABCD PHARMACY\
IR*8005393370*CA CURES\
PHA***AC1234567*ABCD PHARMACY*4 TEST CENTER DR**SACRAMENTO*CA*95820*9165410500*PHY12345\
PAT*******ASAP*TEST****3220 TEST WAY**SACRAMENTO*CA*95620*9161231231**19610101*M\
RX***367998*****20090102************0\
DSP***367998*0*****20090102**01*99999999999**2.5*15\
PRE****AW1234563\
PLN****06\
CDI*01*01*63304015901**15.0\
CSR*******\
TP*9\
TT* PHY12345_010109_01.DAT*15*\
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Correction: I had to do something similar a while back
ASKER
I will check with my client to see if this will help with his situation