<div>
<div class="content wysiwyg-content">
I need to load some data into Access database which is in a text format, and I wanted to write a VBA module which will parse the text file and store the data into the database. &nbsp;But I can't figure out how to access a text file from a VBA module. &nbsp;Any help would very much be appreciated
</div>
</div>


I need to load some data into Access database which is in a text format, and I wanted to write a VBA module which will parse the text file and store the data into the database.  But I can't figure out how to access a text file from a VBA module.  Any help would very much be appreciated

Accessing Text File from a VBA module of MS Access

Hardware includes cell phones and other digital living devices, tablets, computers, servers, peripherals and components, printers and scanners, gaming consoles, networking hardware such as routers, hubs, switches and modems, storage devices and security equipment such as firewalls and other appliances.