Solved

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

Posted on 2011-02-15
7
313 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:ArisaAnsar
  • 3
  • 3
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34899132
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
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 34899151
Define a table with the required number of fields all set as text 255 and import to that.  
0
 

Author Comment

by:ArisaAnsar
ID: 34899155
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Closing Comment

by:ArisaAnsar
ID: 34899206
Thanks!  That worked.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34899208
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
 

Author Comment

by:ArisaAnsar
ID: 34899239
Im using Access 2003.
Where would I add the command?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34899260
never mind
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

775 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question