<div>
Edited text of question<br />

</div>


<div>
You are exactly right. I must admit, I found the same answer through trial and error and using the help files. However, I still feel this was a challenging subject. Thank you for your response. <br />

</div>


You are exactly right. I must admit, I found the same answer through trial and error and using the help files. However, I still feel this was a challenging subject. Thank you for your response.


<div>
I have tried to perform it with a macro and a import specification but it still doesn't work. I'm using Office 97.<br />
<br />

</div>


I have tried to perform it with a macro and a import specification but it still doesn't work. I'm using Office 97.



<div>
<div class="content wysiwyg-content">
I have a macro to import a text file into Access. I am using the Transfer Text Action in the macro section. Under Transfer Type I have chosen the Import Delimineted Type. <br />
The .txt file I am importing must be a | (pipe or pike?) delimeted file. When it imports to a new table, all the columns from the text file remain in Field 1 of my table, all seperated by the | symbol. how can I have my macro specify the | type for the delimeted function. <br />
The obvious solution of changing the text file to a file type such as Excel will not be possible in this case. 
</div>
</div>


I have a macro to import a text file into Access. I am using the Transfer Text Action in the macro section. Under Transfer Type I have chosen the Import Delimineted Type. 
The .txt file I am importing must be a | (pipe or pike?) delimeted file. When it imports to a new table, all the columns from the text file remain in Field 1 of my table, all seperated by the | symbol. how can I have my macro specify the | type for the delimeted function. 
The obvious solution of changing the text file to a file type such as Excel will not be possible in this case. 

Import Text File into Acess using a macro

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.