?
Solved

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

Posted on 2011-02-15
7
Medium Priority
?
320 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 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

864 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