MS Access in Excel

[Guest]

I downloaded the MS Access converter add in for Excel. The first time it
worked and was in the drop down menu to 'convert to Access.' When I opened
Excel again, it didn't. I checked the Add Ins drop down and MS Access is
there. I unchecked it, save, close. Then I opened Add Ins again and rechecked
the MS Access convert feature. Then I could find the MS Access convert in the
Data drop down.

I don't want to have to do this each time. Did I not place the access.exe
file in the right place on my hard drive? Any other suggestions?

 

[Gord Dibben]

Jackie

I assume you downloaded ACCLINK.EXE from this site.......

http://www.microsoft.com/downloads/...09-5D8A-4F53-ABCB-3D3D22774AAF&displaylang=en

You run it and it creates a file named ACCLINK.XLA which is the add-in to load
in Tools>Add-ins

Store it in your Office\Library folder.

When done properly, it will show up in Tools>Add-ins as MS AccessLinks Add-in.

Check that and you should be good to go.


Gord Dibben Excel MVP

 

[Debra Dalgleish]

You didn't indicate which version of Excel you're using, but the
following MSKB article may help:

XL2002: Menu Options for the AccessLinks Add-in Program Disappear
http://support.microsoft.com/default.aspx?id=327767

 

[Guest]

I have Excel 2002 ... Office 10. Thank you.

You didn't indicate which version of Excel you're using, but the
following MSKB article may help:

XL2002: Menu Options for the AccessLinks Add-in Program Disappear
http://support.microsoft.com/default.aspx?id=327767

 

[Guest]

Yes ... I had done all you described. The only way it works is to uncheck it
from the Add-ins, close; Recheck the Add-ins ... then it appears in the Data
drop down.
Thank you.