<div>
Try this instead : 
 
Dim strstring As String 
&nbsp; &nbsp; strstring = FileLen(&quot;output.txt&quot;) 
Open &quot;output.txt&quot; For Binary Access Read As #1 
&nbsp; &nbsp; Get #1, 1, strstring 
Close #1 
 
note : strstring will contain the entire file !
</div>

Try this instead :

Dim strstring As String
    strstring = FileLen("output.txt")
Open "output.txt" For Binary Access Read As #1
    Get #1, 1, strstring
Close #1

note : strstring will contain the entire file !

<div>
<div class="content wysiwyg-content">
Hi All. 
 
First, sorry for my bad english. 
 
How I can get the refreshed version of a file ? 
 
I'm running the sqlldr command from oracle client app to insert data into my database. 
 
I have a batch file that has the following code: 
 
sqlldr userid=comuser/eqfpcom08@pcom2.world control=\dbm\ldr\prd.ldr log=\dbm\log\prd.log 
 
then I execute the shell visual basic command: 
 
shell &quot;batchfile.bat &gt;&nbsp;output.txt&quot; 
 
the sqlldr updates the file when ir runs. 
 
With sqlldr running I goto the windows explorer, I open the file and I can see the output.txt contents. 
 
But if in my code i make this: 
 
Open &quot;output.txt&quot; for input access read as #1 
line input #1, strString 
 
strstring will be &quot;&quot;. 
 
Cand someone help me ? 
 
Thx in advance.
</div>
</div>

Hi All.

First, sorry for my bad english.

How I can get the refreshed version of a file ?

I'm running the sqlldr command from oracle client app to insert data into my database. 

I have a batch file that has the following code:

sqlldr userid=comuser/eqfpcom08@pcom2.world control=\dbm\ldr\prd.ldr log=\dbm\log\prd.log 

then I execute the shell visual basic command:

shell "batchfile.bat > output.txt"

the sqlldr updates the file when ir runs.

With sqlldr running I goto the windows explorer, I open the file and I can see the output.txt contents.

But if in my code i make this:

Open "output.txt" for input access read as #1
line input #1, strString

strstring will be "".

Cand someone help me ?

Thx in advance.

Geting the refreshed version of a file

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.