Hi There,
I am not familiar with HL7 logs, but if they are just a text file with | delimited data, then you can use logparser to pump it straight into your Access database. You can also let logparser determine your data types from the data, so that you will not need to do a data import into Access. Look at the"TSV input Format Parameters" in the logparser.chm help file to get the specifics for the dtLines (data type lines). There are also numerous other parameters which I find useful when parsing non-standard type data. The header line is also very useful to give your elements meaningful names when dealing with each field. The default values of these parameters are generally good to go.
The following example will pump | delimited data straight into and Access database table.
LogParser -i:tsv -iseparator:"|" "select * INTO MyTable FROM sample.hl7" -o:SQL -oConnString:"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\MyDB\MyDB.mdb;Uid=MyUsername;Pwd=MyPassword"
A quick observation for you; why not use logparser to directly analyse the HL7 data? When you get more familiar and start seeing the speed of the processing and start looking into the advanced features in the product, you will find the file checkpointing, multiplexing files, charting of output, creation of web pages for reporting etc etc very useful. This literally obviates the intermediate step of having to transform data from one format to another.
Good luck and enjoy.
Cheers, Dave