Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 762
  • Last Modified:

Unable to import text file into table in Microsoft Access 2003

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
nm67304
Asked:
nm67304
1 Solution
 
FlysterCommented:
Try importing your data into excel. If that works, you can import the excel file into access.

Flyster
0
 
GRayLCommented:
is Microsoft Jet Service Pack 4.0 installed on all the computers?
0
 
nm67304Author Commented:
Thank you for the work around.
0

Featured Post

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now