[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2011-02-15
7
Medium Priority
?
319 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

650 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