I am treating to read a text file with VB to Access using transfertext command but in some computers only read a single column. I have the problem using XP and Windows 98, I had installed all the patches and and I still having the problem.

I will appreciate your help.

Manuel Trujillo

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

I have similar problems, my solution was to save import the text by using an specific layout that you can load/save when importing.
Fran

Thnxs for your help, I am working proggramming my own code.

Manuel