Solved

Unable to import text file into table in Microsoft Access 2003

Posted on 2008-10-27
3
737 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

760 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

21 Experts available now in Live!

Get 1:1 Help Now