advanced button import file

Posted on 2006-05-09
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
    LVL 3

    Accepted Solution

    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

    Under help and about access this states 2002.. Did you mean the Operating system as 2003? Thanks
    LVL 3

    Expert Comment

    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

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    15 Experts available now in Live!

    Get 1:1 Help Now