<div>
The short answer: write an import routine. To help you further we will need the format of the text file and the format of the table(s) you wish to populate.<br />

</div>


The short answer: write an import routine. To help you further we will need the format of the text file and the format of the table(s) you wish to populate.


<div>
You can read data in from your text file using <br />
<br />
'open your data base here<br />
<br />
Open &quot;yourfile.txt&quot; for input as #1<br />
&nbsp; &nbsp;line input #1,sLine<br />
<br />
do until eof(1)<br />
&nbsp; &nbsp;..<br />
''' &nbsp; chop your string up here using mid,left right etc<br />
<br />
&nbsp; &nbsp;rs.addnew <br />
<br />
&nbsp;''' &nbsp;adn populate your database fields<br />
<br />
&nbsp; &nbsp; &nbsp;rs.update &nbsp; <br />
<br />
&nbsp; &nbsp;line input #1,sLine<br />
<br />
loop<br />
<br />
close #1<br />

</div>


You can read data in from your text file using

'open your data base here

Open "yourfile.txt" for input as #1
   line input #1,sLine

do until eof(1)
   ..
'''   chop your string up here using mid,left right etc

   rs.addnew

 '''  adn populate your database fields

     rs.update  

   line input #1,sLine

loop

close #1


<div>
<div class="content wysiwyg-content">
How can I import a Text (ASCII) file into my Access 97 table<br />
using VB 5.0. 
</div>
</div>


How can I import a Text (ASCII) file into my Access 97 table
using VB 5.0. 

Import text (ASCII) file into access 97 from VB5

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.