Sam, just go and read Andy's previous post here
http://www.vbaexpress.com/forum/show...ds-into-Access.

We went right through this and Jonh pointed out that it uses vbLf which is the record seperator and the comma is the field seperator, but it is now completely immaterial, as FSO can read the file correctly where as Opening the file and using LineInput does not.