M
Michael
Hello -
I'm having some difficulties with the "Input" statement and hoping someone
can tell me what i'm doing wrong.
I need to import a delimited file into an Access 2003 database. The file is
an HL7 medical report in case anyone is familiar with that. Basically it is
pipe delimited, the first row contains records for the "MSH" segment, the
second row contains "EVN" records, etc. Then further down in the report
there are multiple "OBX" lines that contain the actual body of the report.
Each OBX line will need appended to the previous one to form one continuous
report.
It's my understanding that the "Input" statement should open the entire
file, including carriage returns or line feeds. However, Input only opens up
the first line of the file for me. This means that in order to advance
through the file, Access is adding a new record for each line. A sample of
what i'm doing:
Open strPath & strFileName for Input as #1
Input #1, myFile
At this point, myFile is equal only contains the first line of the file.
Any suggestions or tips are GREATLY appreciated.
Thank you!!
I'm having some difficulties with the "Input" statement and hoping someone
can tell me what i'm doing wrong.
I need to import a delimited file into an Access 2003 database. The file is
an HL7 medical report in case anyone is familiar with that. Basically it is
pipe delimited, the first row contains records for the "MSH" segment, the
second row contains "EVN" records, etc. Then further down in the report
there are multiple "OBX" lines that contain the actual body of the report.
Each OBX line will need appended to the previous one to form one continuous
report.
It's my understanding that the "Input" statement should open the entire
file, including carriage returns or line feeds. However, Input only opens up
the first line of the file for me. This means that in order to advance
through the file, Access is adding a new record for each line. A sample of
what i'm doing:
Open strPath & strFileName for Input as #1
Input #1, myFile
At this point, myFile is equal only contains the first line of the file.
Any suggestions or tips are GREATLY appreciated.
Thank you!!