Import Spreadsheet Wizard not working

[Guest]

I am trying to import an EXCEL file into a new table and want to be able to
tell access which fields to index and which ones to ignore. However when I
get to the step where I sould be able to select field options as I move my
cursor/mouse over the field names the field name in the select field section
will not change. If I manually try and change it the the first field name is
changed. I have uninstalled and reinstalled Access and that did not solve the
problem so I am stuck. Any Advice?

 

['69 Camaro]

Hi, CJ.

If I manually try and change it the the first field name is
changed. I have uninstalled and reinstalled Access and that did not solve
the
problem so I am stuck. Any Advice?

It means you're at the wrong service pack level for Microsoft Office. You
didn't mention which version of Access you have installed. If you have
Access 2002, then you need to install a hotfix to fix the problem caused by
installing SP-3. If you have Access 2003, then you need to install SP-1 at
a minimum. You may not want to install SP-2 (which removes the ability to
update linked spreadsheets) or SP-3 (which just came out this week and has
some inconvenient bugs in it).

If you have Access 2002, then please see the following Web page for the
hotfix information:

http://support.microsoft.com/default.aspx?kbid=841365

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Yes i have 2002 however I have SP3 also installed and when I tried to
uninstall it I was not alalowed to. From what I have read there is some post
hotfix out there but I can't seem to find out where. Do you know? Thanks
for you help.

 

['69 Camaro]

Hi, CJ.

when I tried to
uninstall it I was not alalowed to.

Sorry. It won't uninstall. That's by design.

From what I have read there is some post
hotfix out there but I can't seem to find out where. Do you know?

The Web page I gave a link to earlier contains a link to the following Web
page, with a phone number and many links to Microsoft's various tech support
categories:

http://support.microsoft.com/contactus/?ws=support

When you contact Microsoft's tech support, ask for the hotfix for Access
2002 SP-3.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Ken Snell \(MVP\)]

This is a known issue for ACCESS 2002 SP3. This issue is described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;875252

There is a Hotfix available for ACCESS 2002 from Microsoft Technical Support
for this problem. Description of the Access 2002 post-Service Pack 3 hotfix
package:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;841365

There also is a HotFix for ACCESS 2003 SP1 for similar issue. Description of
the Access 2003 hotfix package:
http://support.microsoft.com/default.aspx?scid=kb;en-us;837003

 

[Guest]

Thank you both for your help.

This is a known issue for ACCESS 2002 SP3. This issue is described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;875252

There is a Hotfix available for ACCESS 2002 from Microsoft Technical Support
for this problem. Description of the Access 2002 post-Service Pack 3 hotfix
package:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;841365

There also is a HotFix for ACCESS 2003 SP1 for similar issue. Description of
the Access 2003 hotfix package:
http://support.microsoft.com/default.aspx?scid=kb;en-us;837003