MS Access - Is there any easy way to import a .txt file into Access Table

I have really large files in .txt format that has to be imported in Access.  Unfortunately the Import feature keeps producing an error file and none of the data from the txt file are being imported.
ArisaAnsarAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Define a table with the required number of fields all set as text 255 and import to that.  
0
 
Rey Obrero (Capricorn1)Commented:
if the reason is the size of the text file, you can break the text file into several smaller text files and import the smaller text files one at a time.

0
 
ArisaAnsarAuthor Commented:
I have approximately 20 txt files and will have to do this three times a month going forward.  I'm trying to find an easy way.  Do you have another suggestion?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
ArisaAnsarAuthor Commented:
Thanks!  That worked.
0
 
Rey Obrero (Capricorn1)Commented:
you can do that by creating an import specification first, then use command
docmd.transfertext acimportdelim, "import  spec Name",<path to text file>, true

what version of access are you using?
0
 
ArisaAnsarAuthor Commented:
Im using Access 2003.
Where would I add the command?
0
 
Rey Obrero (Capricorn1)Commented:
never mind
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.