Trying to export an Access 97 table to Excel

[alliknowisnetworking]

I have a bit of a problem.

I am trying to export an Access 97 table to Excel. Heres the problem:

I have the table up, then I go to -File-, -Save as/Export-

Then the save as box comes up. In save as type drop down menu,
It should show the Microsoft Excel 3, Microsoft Excel 4, Microsoft Excel 5-7, Microsoft Excel 97, etc. along with all the other different extensions.

The Excel extensions dont show up. This has to be an isolated issue b/c this is the only pc that does not have Microsoft Excel in the drop down menu.

I tried uninstalling Access 97, then reinstalling [no fix]. I tried updating the office suite, [no fix]

Can anyone help? Thanks

"Users are like Prostitutes,..They need guidance"-Myself
A+,Network+,MCP+2000

 

[sawedoff]

Don't know if this will help, but try clising the table (not the whole database) and then right click the table, and choose Export. It may be a differnt approach to the same thing, but it could act differently.

Sawedoff

 

[blanchj]

An other option might be to select an export that excel will import - (txt. or csv).

 

[petrosky]

Hi alliknowisnetworking,

I have come across this problem in the past (but with importing)

Unfortunetely, I have lost exactly where the key was in the REGISTRY - so please use this advice AFTER backing up the registry on the offending machine.

Firstly, go to a machine that has the export capabilities...

Open REGEDIT and drill down to HKLM, Software, Microsoft, Jet. There should be 2 sub folders 3.5 and 4.

You need to open these on the working machine and compare the values and keys present to the ones on the offending machine. Obviously, any missing keys on the bad machine will need to be created by you.

I'm sorry it was a vague answer but it is stricly from (patchy) memory.

Regards,

Peter


Remember- It's nice to be important,
but it's important to be nice