Transfertext - not wroking

[davo]

I am trying to transfer text files into my Access97 DB (on NT 4.0) with VBA. But it does not always work. I mean if it does I have to either do it manually (works always) or step through the macro.<br><br>Would it be due to the netork traffic?<br><br>I start the transfer and then the Task Manager reads &quot;Not Responding&quot;.<br><br><br>

 

[DougP]

Paste your code here<br>And write down the Exact message and Error number<br>And point to which line the error occures.<br>If it does not stop or have a debug option on the error dialog box then &quot;Rem&quot; out the On_Error statement<br><br>Like so <br>' On Error goto --------- <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[davo]

On Error GoTo Import_Holdings_Err<br>TokyoHoldings = InputBox(&quot;Holdings Filename&quot;, , &quot;Holdings file name don't inlc .csv&quot<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>DoCmd.TransferText 0, &quot;GSMAC&quot;, &quot;oldTokyomGSMAC&quot;, FileLocs & Holdings<br><br>Import_Holdings_Err:<br>MsgBox Error$<br><br>I know this works but only at &quot;non peak times&quot; ie when almost everyone has gone home. I talked to the Lan Admin and he said that the NT server was &quot;pretty full&quot;. This must be the case right? I never get to see the msgbox error$ as The Task Manager always comes up with&nbsp;&nbsp;My Access 97 app - &quot;Not Responding&quot;.<br><br>Thanks.