Link to home
Start Free TrialLog in
Avatar of ArisaAnsar
ArisaAnsarFlag for United States of America

asked on

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.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

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.

ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ArisaAnsar

ASKER

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?
Thanks!  That worked.
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?
Im using Access 2003.
Where would I add the command?