Import Text file into VB(MS access) issue due to carriage returns

[chris-uk-lad]

Hi all

I currently have a text file which is interpreting a number of columns as one long string, due to carriage returns (Chr$(13) i think?). I have been having trouble trying to import this text file into an MS Access table using VB code but cannot work it out. So far my script will read in a strong, and populate cells using the mid/instr method using a "while not EOF", but i don't know how to stop at the carriage return and move to a new line

All help appreciated, thanks

 

[chris-uk-lad]

I'd really appreciate if anyone could give mt he slightest direciton of which to follow on this, just has me stumped.

 

[spikepl]

use InStr to locate Chr(13)

or read the file line by line, http://vbadud.blogspot.com/2007/06/vba-read-text-files-with-leading.html

 

[chris-uk-lad]

use InStr to locate Chr(13)

or read the file line by line, http://vbadud.blogspot.com/2007/06/vba-read-text-files-with-leading.html

Thanks for the help, i'm actually running a line-by-line method (while not EOF) but this interprets the full string as being one line, making EOF true and not allowing me to even process the string.

 

[DJkarl]

If reading it in puts it all into one sting use the Split function to break into an array you can use.

variantArray = Split(YourString,vbCr)