can't export from Access 97 to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
We can not export data from Access 97 to Excel (either 97 or 2000). All of
our reports are set to run with Access 97 only, so this is a "must have" fix
for me.
I am trying to set this up on a Dell OptiPlex GX745 that is running Windows
XP SP2 (which apparently is part of the cause of the problem).
I've tried renaming the htmlmarq.ocx, and even renamed it in RegEdit. Still
no luck.
The only choices to save with are Access or RTF, but not Excel.
Yes, there is an icon to choose to Analyze with Excel, but this isn't the
way we want to do it because of formatting and "the look of it".
So I would appreciate if anyone has a fix for it. Every time I try an
uninstall and reinstall, it keeps insisting that Excel drivers are loaded.
But yet it sure isn't a choice for me! ARGH!
Thanks for your help,
Spencer

*** Please note that the opinions and comments expressed above are mine
alone and do not reflect on my company or its viewpoints or standpoints.***
 
Unfortunately, that's beyond my level of expertise.
Can you please advise on how I go about doing that?
Thank you in advance
 
Sorry, you were talking gaily about using RegEdit so I assumed you were
comfortable under the hood. Here's my standard response:

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
That worked perfectly! Thank you very much, John, for sharing your expertise.
I can now roll out the next 35 computers without having to fix each one.
Thanks again,
SpenCer
 
Back
Top