<div>
In Access you can link csv file and create queries for correct import. You will need very small VBA part:<br />
1. Rename (copy) file according to your linked file name (constant)<br />
2. Run import queries<br />
3. &nbsp;Delete imported csv file
</div>


In Access you can link csv file and create queries for correct import. You will need very small VBA part:
1. Rename (copy) file according to your linked file name (constant)
2. Run import queries
3.  Delete imported csv file

<div>
The 2 suggestions combined to provide a good solution.<br />
<br />
Thank you.
</div>


The 2 suggestions combined to provide a good solution.

Thank you.

<div>
<div class="content wysiwyg-content">
I have been getting a bunch of data files in .csv format and using Excel to eliminate bad rows and scrub bad cells prior to import. Now I am getting them as .txt files and when I use Excel to open them I lose leading zeroes that I need.<br />
<br />
I'm trying to adapt this code from an Excel macro into VBA in Access, but I'm using late binding and Access is blowing up on the code.<br />
<br />
Any suggestions on how to &quot;import&quot; in Excel using VBA code would be appreciated.<br />
<br />
Thanks.
</div>
</div>


I have been getting a bunch of data files in .csv format and using Excel to eliminate bad rows and scrub bad cells prior to import. Now I am getting them as .txt files and when I use Excel to open them I lose leading zeroes that I need.

I'm trying to adapt this code from an Excel macro into VBA in Access, but I'm using late binding and Access is blowing up on the code.

Any suggestions on how to "import" in Excel using VBA code would be appreciated.

Thanks.

Automating Excel Text File Import from VBA

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.