Exporting

G

Gavin

Hi,

I'm running Win2000 using office 97 and I'm trying to
export a database from Access to Excel but when I go to
File > Export and click on the 'Save as Type' Excel is not
an option.
I have full Administrative rights to the database and PC.

Any ideas on how to get Excel to be an option?

Thanks in advance.
Gavin.
 
J

Joe Fallon

Very common problem.
This solution is 100% reliable.
If it fails - you will be the first!
Don't let me down!!
=============================

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.
 
G

Gavin

Worked perfectly, thanks a million Joe

-----Original Message-----
Very common problem.
This solution is 100% reliable.
If it fails - you will be the first!
Don't let me down!!
=============================

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.


--
Joe Fallon
Access MVP






.
Click to expand...
 
C

Cathy T.

Gavin, did you ever find an answer for this? I am having the exact same problem in Windows XP and Office 97

----- Gavin wrote: ----

Hi

I'm running Win2000 using office 97 and I'm trying to
export a database from Access to Excel but when I go to
File > Export and click on the 'Save as Type' Excel is not
an option
I have full Administrative rights to the database and PC

Any ideas on how to get Excel to be an option

Thanks in advance
Gavin
 
Top