Solved

Unable to import text file into table in Microsoft Access 2003

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

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

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…
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 …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

679 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