Missing Function in Excel 2003

[Ahmed Gaafar]

Dear All

In Excel 2000 I used to use a function called "MS Access
Form" , which was located under the DATA menu. Since I
have upgraded the Office version to 2003, I cannot find
this function anywhere in Excel. This function takes a
highlighted table, and makes a suitable entry form in
Access to facilitate the data entry process

Best Regards and Thanks in advance
Ahmed Gaafar

 

[Greg Koppel]

You need to load the Access Links Add-In from the Tools menu.

HTH, Greg

 

[Gord Dibben]

Ahmed

You need the Access Links Add-in for your Access Form.

ACCLINK.XLA which is not included with Office 2003 or 2002.

Can be downloaded from this site. Watch for word-wrap, all one line.

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

Note: d/l site says for Excel 2002.

OK also with Excel 2003

Gord Dibben Excel MVP