Office 2003 - no more Office Links in Excel?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

slurpee55

Thread Starter
Joined
Oct 20, 2004
Messages
7,837
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

Joined
Mar 8, 2005
Messages
19,895
On the Data Menu isn't there a "Get External Data"?
There is in Excel 2002.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Well spotted Rich, sorry Slurpee, I can't find anything either, it appears that Microsoft changed it to Importing in to Access instead.
 
Joined
Oct 26, 2005
Messages
354
And I suspect that the OP had Office 97 and switched to Office 2003. Office 98 was the Mac equivalent of Office 97.
 

slurpee55

Thread Starter
Joined
Oct 20, 2004
Messages
7,837
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

Joined
Mar 8, 2005
Messages
19,895
Do you want any help with the Access database?
You can just import the Excel sheet and Access will create the table for you.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top