CSV Import 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.

 

[opvk]

If you are importing a *.cgi and then converting it into *.csv here is what I do,
Create a table in XL and then link it to the CSV (Edit>link>open source)and then all the datas in the csv are in then in the XL.Its a normal procedure to convert the Xl file into a table.

If this doesn't work please describe your problem in detail.

Winners don't do different things
They do things differently

 

[misterhux]

Thanks alot for your help.


But 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.