I find transfertext unusable for most purposes as it is not possible to do record/field validation. If you can parse a string on delimiters you are much better off writing your own import routine. Have a look at:
http://www-personal.ksu.edu/~sgsax/
follow his downloads link and then open the link to 'File I/O in
VB'. The first example shows you how to open and read a file. Add your own field parsing routine depending on how it is delimited. I always use an Access 97 parsing routine as it doesn't rely on string reverse functions or split routines that weren't available in the 97 version for backward compatiblity.
If you write your own routine, you'll never have problems with dll conflicts, uninstalled features, application versions, file name extensions etc. It will just work all the time plus you can provide write validation code to flag incorrectly imported records for manual review.
Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com