<div>
<div class="content wysiwyg-content">
I'm a VB programmer working on an Access 2007 Database. &nbsp;Very unfamiliar with Access 2007.<br />
<br />
I need to perform these functions and I'm rushed for time:<br />
1. &nbsp;I need a file dialog that will allow the user to Select a CSV file that resides in a Specific Directory. &nbsp; How would I add this control to a form? &nbsp;Do I need to add references and components?<br />
<br />
2. &nbsp;I need to extract data from the selected file to store in another table. &nbsp; &nbsp;What is the best way to extract data from a CSV?<br />
<br />
Thanks in Advance<br />
KF<br />

</div>
</div>


I'm a VB programmer working on an Access 2007 Database.  Very unfamiliar with Access 2007.

I need to perform these functions and I'm rushed for time:
1.  I need a file dialog that will allow the user to Select a CSV file that resides in a Specific Directory.   How would I add this control to a form?  Do I need to add references and components?

2.  I need to extract data from the selected file to store in another table.    What is the best way to extract data from a CSV?

Thanks in Advance
KF


Need to get somewhere quick in Access 2007

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.