<div>
Yes you can create a Basic module, in this module open your text file with Open and read &nbsp;the file using Line Input #1 or input #1.<br />
<br />
You'll have to devise code to process your file and the send it to your form using SendKeys<br />
<br />

</div>


Yes you can create a Basic module, in this module open your text file with Open and read  the file using Line Input #1 or input #1.

You'll have to devise code to process your file and the send it to your form using SendKeys



<div>
I think it is a better solution to link the csv file into the Db and then treat it as if it is a table. Then U can use Dlookup or search or whtever you want in code on thet recordset<br />
perove<br />

</div>


I think it is a better solution to link the csv file into the Db and then treat it as if it is a table. Then U can use Dlookup or search or whtever you want in code on thet recordset
perove


<div>
That's exactly what I want to do - Link the entire csv file to an existing table. &nbsp;Everything is real standard here... the import wizard can do the job in one click. &nbsp;Is there simply a way to hide this process from the user?<br />

</div>


That's exactly what I want to do - Link the entire csv file to an existing table.  Everything is real standard here... the import wizard can do the job in one click.  Is there simply a way to hide this process from the user?


<div>
Have a look at the Transfer Text method in help. You can specify a filename (which you could get from a common dialog control) and a destination table.<br />

</div>


Have a look at the Transfer Text method in help. You can specify a filename (which you could get from a common dialog control) and a destination table.


<div>
<div class="content wysiwyg-content">
Does anyone know if there's a way to have access automatically add to a table from a standard csv text file? &nbsp;Something along the lines where the user clicks a button, finds the data file, then access does the rest of the work.
</div>
</div>


Does anyone know if there's a way to have access automatically add to a table from a standard csv text file?  Something along the lines where the user clicks a button, finds the data file, then access does the rest of the work.

Automating data entry in Access97

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.