Import text file into Access db

[denko]

Hi
I've txt file delimitted by slashes
John Doe/66688.99
Den Kor/777.99
I'm using Open FileName for Input Access method to import it to Access Db
but I'm having difficulties to put each field into its own column. Basically my question is
How can I force VB put data to the next column as soon as "/" is found?
I'm using VB5 so I can not use Find method.
Thanks.

 

[guestuser]

You can use the INSTR function to find where the slashes are and use the left/right/mid string functions to get the individual pieces of data that you require.

Hope this helps

Bill