Solved

Unable to import text file into table in Microsoft Access 2003

Posted on 2008-10-27
3
739 Views
Last Modified: 2012-05-05
I have a client that is trying to import a .txt file into a table in a Access database. When attempting to import the txt, we are clicking New -> Import Table. Selecting the text file. When it brings us to the import text wizard, it must be fixed width, we click Advanced option. It then hangs up on Access. We tried this on 4 different computers, only 1 works.

We attempted to repair the Access installation and compare setup options and eveything looked identicle. What would  prevent the advanced option from loading on the import text wizzard?
0
Comment
Question by:nm67304
3 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 22816269
Try importing your data into excel. If that works, you can import the excel file into access.

Flyster
0
 
LVL 44

Expert Comment

by:GRayL
ID: 22816771
is Microsoft Jet Service Pack 4.0 installed on all the computers?
0
 

Author Closing Comment

by:nm67304
ID: 31510485
Thank you for the work around.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now