MS Access in Excel
 

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?
--
Jackie

Jackie

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

http://www.microsoft.com/downloads/d...displaylang=en

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

Store it in your Office\Library folder.

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

Check that and you should be good to go.


Gord Dibben Excel MVP

On Thu, 10 Feb 2005 06:19:01 -0800, Jackie
wrote:

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?

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


Jackie wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

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


Jackie wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

"Gord Dibben" wrote:

Jackie

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

http://www.microsoft.com/downloads/d...displaylang=en

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

Store it in your Office\Library folder.

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

Check that and you should be good to go.


Gord Dibben Excel MVP

On Thu, 10 Feb 2005 06:19:01 -0800, Jackie
wrote:

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?