[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


advanced button import file

Posted on 2006-05-09
Medium Priority
Last Modified: 2012-06-21
When I use the wizard to import a text file ... I click on advance and the application will keep running forever.. I have to end ... the file has 5 records.. I tried to import on anothers PC with access and I can use the advanced option... Was access loaded bad on my pc?? or do I need to turn something on ??
Question by:brontes1
  • 2
  • 2

Accepted Solution

RohitPattni earned 1000 total points
ID: 16646854
Hi there are two ways to resolve this. I have listed the first opriotn based on access 2003. If you are using a differenct version then let me lknow.
1. Install the imort wizard as an addin. Goto Tools > Addin> Addin Manager > Add new. You will then see 3 files ACWZLIB.MDE, ACWZMAIN.MDE and ACWZTOOL.MDE. Add all 3  and then restart access. You may should be abe able to use the advances import button.

2 Reinstalll access with all options selected. This will bring the import wizard that will allow you to use the advances settings.


Author Comment

ID: 16649698
Under help and about access this states 2002.. Did you mean the Operating system as 2003? Thanks

Expert Comment

ID: 16650184
No there are different version of Access  ie 97, 2000, 2002 or XP and then 2003. Try option one, but I am not too familar with 2002, I work with 97, 2000 and 2003. If not you can alway re install. ,


Author Comment

ID: 16651847
thanks - maybe ms website would have more detail if that does not work .. I am going to try.. Also I installed the help files thinking this might help .. no luck

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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 …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

873 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