Jacob, thanks for the reply, see response to Sheeloo.

--
Richard


"Jacob Skaria" wrote:

Please let us know more about the format of the file.

One of the reasons would be the text file may not be separated with a vbCRLF
but only with vbLF

If this post helps click Yes
---------------
Jacob Skaria


"RichNida" wrote:

I import txt files all the time with no problems, now when I try to import
using excel, it only imports the first row only?

--
Richard