Reading Text File

[boblovesyousomuch]

Hello,

I have a text file storing comma delimted values. I would like to pull the string from the text file into a value.

ie.

Dim strIn s String

strIn = (Line from text document)

The text doc will never have multiple lines.

Any help greatly appreciated.

Carl

 

[MakeItSo]

Dim a as Integer, str as String
a=FreeFile
Open "Your text file" for Input as a
Do While Not EOF(a)
LineInput a, str
process your str variable here
...
Loop

If you need more info, a short look into help index, look for "LineInput" or the Open method should give you all info you need.

Greetings,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[boblovesyousomuch]

LineInput doesn't work

I am using Access 97 is that why, is there an alternative way?

Thanks

 

[MakeItSo]

Sorry, posted it th worng way. It's used as:

Line Input #a, str


Must work - it's standard.

Regards,
MakeItSo

 

[boblovesyousomuch]

It does now,

Thanks, there was no space between Line and Input.

Cheers

Carl