Office 2003 - no more Office Links in Excel?

[slurpee55]

I recently switched from Office 98 to 2003 and was used to being able to go to data, export in new Access database (or something like that). This doesn't appear to be an option anymore. Does anyone know of a work-around or MS download or add-in that will allow this?

Thanks in advance....

 

[OBP]

On the Data Menu isn't there a "Get External Data"?
There is in Excel 2002.

 

[exegete]

I think the OP wants to reverse the direction - from Excel to Access.

 

[OBP]

Well spotted Rich, sorry Slurpee, I can't find anything either, it appears that Microsoft changed it to Importing in to Access instead.

 

[exegete]

And I suspect that the OP had Office 97 and switched to Office 2003. Office 98 was the Mac equivalent of Office 97.

 

[slurpee55]

Yes, everyone, I searched everywhere at Microsoft and they don't even mention the feature, which I really found useful - now I will have to create and Access database and import the Excel data - not a big deal, but at least 2 extra steps that used to be automatic.
If anyone knows why they did this (security reasons?) or of some add-in that would allow Excel to directly create an Access database I would be very grateful. Sigh, understanding the mysteries of MS....

 

[OBP]

Do you want any help with the Access database?
You can just import the Excel sheet and Access will create the table for you.