Text File Make Me .....

I have to import data from text file to the database.It take a much time to do it complete.I want to make something to interact with user to make user feel the computer does not hang.I try to use Progess Bar to solve this problem.I try to use No.of current position in text file devide by size of the file but I cannot find no.of current position.May anyone help me to solve this problem?

Thank You,
Pramoch Keawkarsem

set the Min of the progressbar to 0 and the max to 100. Then keep making the value equal to the (current position / total size) * 100. That should work.

But I cannot find the current position that the cursor pointed.

sorry, I can't help you :P

guess me?

What do you mean? The cursor as in mouse? of the current read/write position within the file?

To find the read-write position, use the Loc function.

How?

VB Code:

MsgBox "Current read/write position: " & Loc(1) 'This will return the current read/write position file #1