CSV file not importing the last line

[misterhux]

I'm having a major problem with my docmd.transfertext

for some reason it is not importing the last line of the .CSV file. I looked at the last line, and it ends in a carrage return, and when I load the .CSV into excel it works fine.

does anyone have any idea on how to fix/work around this?

thanks alot.

(I know I also posted this in Access Other topics, but I really need an answer)

 

[misterhux]

Stupid me, I ended up figuring it out. That's what happens when you take a break and go do something else for liek 20 minutes the solution just pops in the head.