<div>
Thanks agj, I didn't realise you could thing like that with the Dos prompt!<br />
<br />
I typed it typed it in exactly as above, including spaces and got this message: <br />
<br />
&lt;&nbsp;was unexpected at this time<br />
<br />
In case that makes in difference, &nbsp;I'm using Windows XP and the file names look like this: &nbsp;AAC.AX_D <br />
<br />
<br />

</div>


Thanks agj, I didn't realise you could thing like that with the Dos prompt!

I typed it typed it in exactly as above, including spaces and got this message:

< was unexpected at this time

In case that makes in difference,  I'm using Windows XP and the file names look like this:  AAC.AX_D




<div>
<div class="content wysiwyg-content">
I have a large number of &nbsp;ascii files stored in a folder c:\tmp. <br />
Each file has four columns seperated by tabs. There is no header row. &nbsp;<br />
<br />
Here are a few rows from one file: <br />
08/13/2004 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AAC.AX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7212730<br />
08/16/2004 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AAC.AX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;675351<br />
08/17/2004 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AAC.AX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;161616<br />
<br />
I want to import the contents of these files into a single table, using the same column order. &nbsp;<br />
<br />
Is there a quick and easy way to do this using Access VBA? <br />
<br />
Thank you! <br />

</div>
</div>


I have a large number of  ascii files stored in a folder c:\tmp. 
Each file has four columns seperated by tabs. There is no header row.  

Here are a few rows from one file: 
08/13/2004	AAC.AX	1.4	7212730
08/16/2004	AAC.AX	1.4	675351
08/17/2004	AAC.AX	1.4	161616

I want to import the contents of these files into a single table, using the same column order.  

Is there a quick and easy way to do this using Access VBA? 

Thank you! 


Macro to import ascii files into a table

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.